Mac Forum / Applications / Excel / April 2008

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I have hundreds of Excel files created in Office 2001 format. Is there a way to convert them all to 2008 .xls format without having to individually open and save each file?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I am not given the option to add labels to the X and Y axis, why is this and can it be done and if so how. Its starting to frustrate me a little, so any help would be much appreciated.

I've just moved from Win to Mac and when I tried to evaluate a formula
in Excel 2004 for Mac, I couldn't find the function.  Have they moved
it, or is it just missing?
Thanks.

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
My office computer has Mac OSX 10.4.11 and Excel 2004 11.0.
I am attempting to create a template worksheet for billing invoices, and I'm using border lines between the columns. I'm doing sample invoices to print and see how they ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Hi, first let me explain, I am a real estate agent and have a mailing list that has over 8000 entries of peoples names, addresses, and size of the property they own.

Is there a way to set recalculation to manual for a particular
workbook (Excel 2008)?  If I understand correctly, if I set recalc to
manual in preferences, then it would affect all workbooks.
Thanks.

Version: v.X
Operating System: Mac OS X 10.2 (Jaguar)
Processor: Power PC
When I create a spreadsheet with several pages very large gray page numbers appear across each page making it difficult to see cell data. How can I eliminate these large page numbers?

i have an easy solution for you to import these charts:
- open the excel file and choose the chart you wish to import (it is
important that you highlight the chart by clicking on the outer most
border)

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
I have set up 20 worksheets for individual tenants and have linked the individual sheets into a summary worksheet. But I get the message "Formula is too long", so I am only able to sum up 16 of the tenants.
What do I do?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I am trying to run a formula to count the number of times a certain result appears ie win or loss. The problem i have is that i only want to use certain cells from the row to run the formula according to ...

How does one do an ANOVA Table in Excel 2008 now that Microsoft
dropped Visual Basic?
Ed

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I have not found any way of stopping the SOLVER in the middle of execution. Does anyone know how to do that?

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I have a very large workbook composed of up to 12 worksheets, all very heavy (numerical integrations). Oftentimes I don't use all of them, e.g. just 4 or 5. How can I suppress re-calculation of the ...

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I have found a way of creating variables that are specific to a worksheet (rather than to all worksheets within a workbook), but it is very cumbersome and limiting. Does anyone know how to do this?

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I tried the new window feature. It's great.