Mac Forum / Applications / Excel / July 2007

If i used 1000 columns in excel 2007, then safe the file to be use in excel
2003, it will be possible to see all the columns when opening the file in
2003?or information will be lost?

I would like to know if there is a way to name a cell based upon its
contents, changing when its contents change.
For instance, i am composing a detailed list of about 20 server boxes
components and power consumption, and rather than having all the

I have made a table on one worksheet page, and a set up a lookup
function on another page in the same workbook.  Here is my formula
=LOOKUP(C2,'Whole Genome Lib'!A:A,'Whole Genome Lib'!C:C).  The lookup
function works great for a while, but at a particular point in the

I have and Excel 2003 document with two columns of data.  Column A holds the
date an event occurred (mm/dd/yyyy formatted as a date).  Column B holds text
indicating the outcome of the event.
I need to find a total of each specific outcome during a specific period of

I have locked a the cells on an excel workbook and password protected them.
When I try to unlock them the password that I thought I used doesn't seem to
work... Is there a way of removing the cell protection?
Thanks

I tried to respond to a previous post related to this issue and was
not able, so I'm starting a new thread.  I'm assuming the thread was
too old to respond to, my apologies for crowding the group.
I have seen similar postings on this list regarding the same issues,

I have created a worksheet that offers users to print out a finalised
document.
The sheet list various questions one of which is, How many family members
are there and for the names, addresses, contact numbers etc to be entered

I'm using a iMAC with Excel X for MAC Serevice Release 1.  When I
press "enter" the active cell drops down one row.  How can I get the
active cell to remain the same?

I created an excel file document size 2MB. I wanted to reduce the
size.
My colleague with VAIO could compress the images by holding down ctrl
click rt. side of mouse and compress easily the file to 455KB. I tried

I have a very specific question regarding a real estate investment
analysis using the financial function, Internal Rate of Return (IRR).
I have calculated my series of cash flows in months, starting with an
initial cash outlay in Month 0 followed by negative cash flows in

Can anyone recommend a good statistical package (add-in) that runs on
Mac Excel X.3.6?
Ed Volchok

very simple question. When I create a macro that I want to use with a
lot of different files, where do I store it. I can store it in the
excel file I created it in or in another excel file, eg, the 'Personal
Macro Workbook'. But I only have access to it when I have the file in

Weird bug.
Put 250 in a cell.
Go to another cell.
Go back to the 250 cell and click on the "edit formula" button. it

I have 2 worksheets, of which some cells are linked, to ensure the 2nd
worksheet calcultes based on the data entry of the first worksheet, I want to
ensure one cell is not blank, in other words remind the user to fill in the
cell or it will not calculate or save the file?

I have a data base of names and addresses of businesses in Excel and I
would like to create a list of all of them with just their Names,
Addresses, City, State and Zip codes so I can print them out as labels
on standard sheets of labels from Office Depot.