Excel 2008 running very slowly - OS 10.5.8

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel In the last two months I've noticed Excel running very slowly. I didn't make any changes and I've run the Microsoft updates and any Mac OS Updates available. I am running 10.5.8 and Excel 2008. Any suggestions would be appreciated. It's frustrating to say the least!

Sub totals of expenditure

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello, I would appreciate some help in creating a budget worksheet in Excel 2004. Can someone please put me on track. I copy paste details of expenditure into a worksheet. I would like to create subtotals of different types of expenditure from the full list. Is it possible to create my own list of sub items labels and then assign each cost item from the total list to one of these sub item label, and the resulting total of each cell with an assigned label to be posted on the worksheet? Many thanks in anticipation

Microsoft SQL Analysis Services

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel On Excel 2007 you have the option of connecting to SQL Analysis Services, something I cannot find on Excel:Mac 2008. Is this a planned feature of Excel:Mac 2011 or is this a reserved feature for Windows versions? <br><br>Thank you in advance, <br><br>Valerio

expiration notification

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have to track certifications for many people, I want to have a alert come up prior to the recertification date. I wanted to have the dates show up in a different color which i was going to use the conditional formatting. I am having problems setting up a formula to trigger the color change. Any help would be greatly appreciated, Tried the E date and date feature but had no luck

Auto refresh ODBC data

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hallo, <br><br>I import data to excel spreadsheet via ODBC (market quotes from trade terminal) How can I make this data refresh automatically (for example every 1 minute) because now the data refreshes only if i push &quot;Refresh all&quot; button? <br><br>Thank you for your answer and sorry for my English)

How to go to next row first column

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel When entering data In the 2004 version, when I hit Return, the cursor would go to the next row and the 1st column of the spreadsheet. Now I can't seem to make it do that in the 2008 edition. In Preferences I have the option to choose after pressing RETURN move Left, Right, Up, or Down. I want to go to the first cell in the next row. How do I do that?

Printing is very light in Excel ONLY

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a brand new Mac computer. I just hooked up a brand new Canon PIXMA MP490 printer. It prints everything correctly EXCEPT documents I've created in Excel. I still have my old printer and it prints Excel documents just fine. Canon helped me reinstall the drivers but I still can't get a good black and white document from Excel. What could be the problem? Word documents print just fine.

Trying to delete multiple cells that contain a specific word (not equation)

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I've had to export a form from QuickBooks Online to Excel so I could manipulate it. Within a column there are 115+ cells that contain a specific word that I need to delete all those cells. Is there something as easy as find and delete, rather than find and replace? I can't believe that I have to delete each cell individually.

automatic changes on my workbook

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel <i>have created an extensive workbook and now whenever i open it up, with out me making changes, when i try to close it the workbook asks if i &quot;want to make changes to the workbook&quot;</i>&#32;<br><br>how can i check for the changes being made to the work book? <i>know that i am not physically making them- sometimes i just open the workbook to check on this- and close it right away- same message</i>

Data Form/Dialog Box

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I would like to create a dialog box for my expense report. <br><br>My company has a spreadsheet they like me to use...but I loath moving cell to cell to enter my data. <br><br>I would like to create a dialog box or data form (not sure of correct terminology) that I can enter the data in (date, $$, choose category...etc) and have it land in the expense report. Even adding additional rows if necessary. <br><br>I tried the Data>Forms function...but wanted something a bit more advanced. <br><br>I can follow tutoria

Search and copy files. Look up destination folder in a range

I need help in doing this: I have an excel worsheet that have columns for destination folder and corresponding file to search for. The files to be search for will have wild cards e.g *total*.*. What I want to do is create a macro that will search for call values in a range, copy the result of the search to the corresponding destination folder for example column A(files to search for) column(Destination folder) column c (source always c:\documents) *total*.* total_cost c:\documents *accounts*.*

How can I create a shortcut for "paste special" + transpose?

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel I need to do a lot of copying from one data orientation to another and use a lot of repetitive copy, paste special, transpose. It's a pain in the neck to use the mouse for this. Can I create a keyboard function or a single click button? I recently discovered how to record a macro in my previous version of office, which, although I couldn't work out how to apply it to all new workbooks, it was quick to set up in a new workbook. Now that I have upgraded to 2008 I cant even do that anymore. There seems to be a lot of peop

File Reservation in Excel 2008 - cannot open shared file as read-only

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel It used to be that when a document was opened by another user on the file server, you could open the document as read only. Excel now seems to think any of these files that are already opened are now corrupt. <br><br>In our network environment, users are on Intel Macs, running 10.5.8 and MS Office 12.2.3. Everyone has access to a file server running Mac OS Server 10.5.8 via AFP and the shared volumes are on an XSAN. <br><br>The issue is that when a user opens an &quot;.xlsx&quot; file on the file server that anothe

how to paste a series formula across worksheets?

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel <i>have a budget workbook w/12 worksheets, 1 per month. i have a row of starting totals for each month. how do i copy the starting total in january's worksheet and paste it across the following months' worksheets in increasing months? Ex: in january's worksheet, cell A2 has the total of $100. in february's worksheet, the formula in A2 is: &quot;=100+Jan!A2&quot;. how do i copy/paste the formula across the rest of the worksheets so that they read &quot;=100+Feb!A2&quot;, etc. w/o having to manually enter in

Picture/Object in List

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel How do I associate a picture(object) to a specific cell in a list, so I can sort, filter, etc. (Normally objects just &quot;float&quot; on a spreadsheet and if you sort, objects will not move with the row they are placed.) <br><br>Thank you,

Big Bug in Excel Applescript?

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, <br> could you please try the following applescript on your Excel 2008 for Mac? <br><br>tell application &quot;Microsoft Excel&quot; <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;select range &quot;A1:C3&quot; <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get address of rows of selection <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;select range &quot;B1:D3&quot; <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get address of rows of selection <br> end tell <br><br>I get the fo

Shortcut for diferent shading colors

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi there, i've searched all over the net into how to create a new shortcut for diferent shadding colors, example : command+control+a to fill de sheet in a red color, command+control+s to fill the sheet in a green color and command+control+z to fill the sheet in a purple color... is there a way to do that? in windows i've used a macro to do that but since excel 2008 doesnt have this options what do i need to do? thank you

Excel won't reopen

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello, <br><br>I tried to move Excel to the dock but something went wrong. When I tried to open it Excel crashed. Now every time I try to start it, I get the message that Excel quit unexpectedly. However, Excel does not reopen. <br><br>Holding Shift down while I try to re-open Excel does not help. I have repaired the Disk Permissions, but that does not help either. <br><br>I hope you can suggest a solution. The error message is reproduced below. <br><br>Thanks <br><br>Sami <br><br>Process: Microsoft Exce

filtering a mailing list

Operating System: Mac OS X 10.5 (Leopard) How do you filter a mailing list by zip code?

size of window upon opening a spreadsheet

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel When I open my spreadsheet, sometimes it opens to a window that only shows the cells I want to see. Other times it opens showing those cells plus several rows and columns larger. Why does it not always show the area that was shown when it was last saved?

formula error

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel =COUNTIF(DIARY!$I$2:$I$3068,1) <br> The above formula does not automatically update to increase the range of cells as new data is being added to sheet diary. How do I correct this. Also the sheet has over 200 items. Do I have to correct the formula for each cell or is it possible to correct the range in all at one go? <br> Thanks

formatting cell in template

Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I want to know if it is possible to format a cell in a spreadsheet, that we use as a bid template, so that the a number will increase by 1 each time the template is opened to start a new bid. This will allow us to assign a job no. to each new job without having to go open the last one each time to know what number to assign.

having excel create a new column in a highest to lowest format

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) sorry it sounds confusing but im not sure if it really is. <br><br><i>have a list of names in one column and then a list of numbers next to it, associated to each name. i would like to create a new column where excel automatically takes the highest 7 numbers and puts the names associated to those numbers in rank from highest to lowest. Is this possible? Is there a formula that can do this? Thanks</i>

Sum function

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am trying to put together a spreadsheet for a business plan and am having problems with the autsum and autofill functions. Firstly, even though I do a simple autosum, if I change a value in a cell, the sum does not change. Secondly, if I try to autofill across columns, the values of those columns simply mirror the value of the first. In other words it copies it. I am at a loss how to get round it as I have been working w Excel for years and have never had this problem. I have experimented with a new worksheet with

Excell

Version: Older version Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Is it possible to match identical data between two or more columns?

how to name a column

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I want to give my columns names without using a row number. How do I do this? And, where do I find &quot;Ledger Sheet&quot; under the &quot;Name&quot; box in the formatting palette? <br><br>thx <br> debcoo

Excel 2008

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, <br> I am a new Excel 2008 user and notice that the 2008 formula bar is missing the &quot;x&quot; and &quot;check mark&quot; feature of the 2004 formula bar. You will remember that the Excel 2004 formula bar has a red x and green check mark which one could mouse click to negate or confirm an entry in the formula bar. I have searched Help, Customize and Preferences but have found nothing regarding this. Does anyone know how to get this feature back or is it gone forever? <br> Thanks <br> Delano

right problem

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, i'm working with a coworker on PC with office 2007. We have both access to a shared folder (onto a leopard server). When the PC save a document and close it, it opens as a read only file. We have both read-write permissions into this folder. I don't have this problem on a 10.5 mac. Note that i can save the document onto the dekstop and then drop it into the shared folder, it replaces the file without any problem!! <br> is there a change into the way office operates right access with 10.6 system ??

Axis labels for line graphs...?

Version: 2008 I am doing a science project and want to know how to make the x- and y-axis labels for a line graph, x being the number of days and y being the height for my experiment's purposes. There is one data set that is completely zero for all 23 days of the experiment that was recorded, and yet it comes up as another data set. Why? And how can I fix it? How, too, can I add x- and y-axis labels for a line graph? Answers welcome and greatly needed.

Frequency / Entering Array Formulas

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel In this post <br><br><a href="http://www.officeformac.com/ms/ProductForums/Excel/4566">http://www.officeformac.com/ms/ProductForums/Excel/4566</a> <br><br>two options are given for finishing the array formula: CMD+ENTER and CMD+SHIFT+ENTER <br><br>Unfortunately, neither are working for me. The documentation and, indeed, the UI for Excel 2008 for Mac really just seem a bit of a mess. At the very least, there should be a video somewhere to try and help poor souls like me work out why this isn't working

"read only" message

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I get a &quot;read only&quot; message after anyone else in the office opens this company shared spreadsheet? The file is closed but I am not able to open it to make changes. We have to copy and past to new sheet and throw way the old one. We had no problems with this up until about 2 weeks ago and then this error stared happening,. . . <br><br>Any Advise??

If/Then Formula

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a column of cells that contain yes or no answers. What I need to do is write a formula that will result in a summary cell that answers &quot;yes&quot; if all of the above cells say yes or answers &quot;no&quot; if any of the cells above say no.

Such a difficult function

Hi Vacation days allowance are depend on 3 criteria for years/ say, 5 - 10 years=2 days 10-15 years=4 days Over 15 days=6 days Now, i have a list with years and months. Say-Q15 contains number "8 years 8 month 10 days". Columnd R contains 30 days (Main vacation allowance is 30 days) . In column S , I need to put in a cell formula calculating total vacation days depending on above 3 criteria. eg. " if person worked more than 5 year , but up to 10 years, then 2 days are added to main vacation days e.g.30+2=32 days, if not then, 30"/ However, i need to include in formula all

Excel number formatting

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a problem formatting some of the cells in a sheet to currency or accounting. I've tried everything from copying and pasting the number formats from other cells,but without any success.

Cannot rid of a formula in a named cell, cannot find the named cell

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am re-posting this question as I have had no replies but the problem continues: <br><br>I have recently saved a workbook as a new file, under a new name. Every time I save the file I get the following message: <br><br>&quot;A formula in a cell (Name: Telecom) could not be converted because it contains a function that is not available in the file format to which you are saving.&quot; <br><br>When I first saved the file there were several named cells identified that I was able to find and delete, and this last o

Freeze panes

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I would like to freeze all of Row 1 AND all of Column A. When I freeze one, then go to freeze the second, it will not let me. The only freeze option is to unfreeze panes? Can both be done at the same time?

stacked column- value axis not displaying correct values

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have created a basic chart showing sales numbers vs. plan for January, February and YTD. The original chart was created as a clustered column chart, but I would like to make it a stacked column so sales and plan are displayed in one column for each month. When doing this the vertical value axis scale adds plan and sales together and makes it appear that sales are higher than they actually are. I need help figuring out how to change the vertical value axis so it displays a value near the actual sales number. <br><br>example of

Can Bar Chart/Column Chart show 2 lots of info per column

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC I need to compile a bar chart that shows a gross figure for every week (so I will have 52 'bars' of varying heights). I also need to show what proportion of each bar is made up of a certain item (i.e. if week 1 revenue = 12, and best selling item = 8, the first bar will be 12 units high, but two thirds of it (8 units) will be a different colour). <br><br>I'm sure there's a clearer way to explain this - apologies if this is confusing. <br> Any help gratefully appreciated. Excel novice. <br><br>Using Excel 2004 for M

Inserting characters into excel

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I need to insert a squared sign into excel however there is no such character in the symbols section. <br><br>any advice would be much appreciated

Excel Time Logged Out

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel As of recently (over the last few days), whenever I use Excel, I am unable to shut down my computer afterward without it freezing. A message appears saying something along the lines of &quot;excel log out failure&quot;, and the only way to end the program is to force quit. After I force quit, I'm able to shut down the computer. I was wondering what was causing this and how to fix it. <br><br>Thanks.

Very slow Excel

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Has anyone found the fix to sort out our very very slow Macs running Excel? <br><br>It's driving us all crazy!! <br><br>Come on microsoft

Formatting cells

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel All of a sudden when I try to format a column of or an individual cell (format as a number, no decimal places, comma for thousands) only 2 of the four numbers appear in the cell. When I double click to view what is actually in the cell I see the four numbers I entered, the first two separated by the last two with a decimal. <br> I have tried this on new sheets and workbooks and the same thing happens.

Currency symbol showing after the number (Part 2)

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, I've noticed that there was a previous post about this issue, but I think it was never answered. <br><br>I'm from Mexico too, and I have the same issue. Even though, my international settings in system preferences are alright, excel shows me numbers like these &quot;1,234.56$&quot;, it should be &quot;$1,234.56&quot;. Also I have problems with the default page size, it must &quot;US Letter&quot;, but Excel and Word always show me &quot;A4&quot;. <br><br>OS X and Excel 2009 are in spanish. <br> My internati

Creating folders from Excel Columns

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Every week I have multiple sheets that I need to make folders from. The info I need is in a concatenated column. Example: <br><br>1234Shoe blue <br> 4567bag red <br> etc... <br><br>and this goes on for over 100 items. Each one needs to be a different folder. Is there a way to automate this and not just copy and paste each one?

Change date format to European format

My computer is set to European date format but Excel is default to American date format. Can someone advise how to change this default setting. Thanks, Scott

Gridlines in Keynote

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I've created a pie chart in Excel and want to cut and paste it into Keynote. When I do that, fine grid lines show up in the image in Keynote. They do not appear if I save the image as a PNG and then import into Keynote. <br><br>I appreciate any responses. <br><br>Thanks, <br><br>Jason

Opening Excel workbook on PC from Mac

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Hi, <br><br>I am experiencing challenges to open a workbook with a PC at work using office 2000 when I saved the file at home on my Mac using Excel 2008 (Leopard OS X 10.5.8). <br><br>I worked on my workbook at home, on my Mac without a problem opening the file saved from my PC at work. I am a new user of Mac Office Home edition and find it very easy to work with. I saved the format 97-2004 (.xls) and opening the next day at work, but I get very frustrated when I found the repaired file from office PC. Formulas and data are there but

Web query from password protected page?

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, <br><br>I'm trying to create a web query from a web page that requires a username and password. I have tried logging into the site in Safari (as well as Chrome and Firefox) before running the query, but when I do run it, the only data that's imported into excel is &quot;Username&quot; and &quot;Password&quot;. <br><br>In the MS version of Excel it's pretty easy to enter the login information into the query (either directly or using VBA), but I can't figure out how to do so in Excel for Mac. Does anyone kn

Can not modify Excel on Server share ONLY LOCAL

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Help, When I create a file using excel on my desktop(local) and save it to desktop, its fine I can modify it and change it. But when I put it on my server on a share directory I can not modify it. It gives me a error. I drag it back to desktop and it WORKS! Problem lies only while its on the server. <br> NOTES: the file has full read and wright rights. <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Its only with ANY excel. Word and Powerpoint Work fine. <br><br>Any ideas please

Chart formatting problems

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Running Office 2008 on Mac OS X 10.5 Leopard <br><br>I am having problems with chart formatting (specifically formatting data labels). I've made all the changes I want and I can save the file, yet when I close it down and reopen it, the changes are lost. For example, I've changed the font type, size and color of my data labels and have rotated them 90 degrees counterclockwise but even after saving my changes, the document reverts to Excel's standard font and rotates my data labels horizontally. <br><br>I am actually