Mac Forum / Applications / Excel / February 2007

How do I remove corrupted Excel Chart Preferences?

This newsgroup has been amazingly helpful to me in the past. Things
have gone well for a long time now, but here I am with a new 'need' and
a hope that it can be done.
I am trying to build an excel file for a family member that will list

I have used a company expense report one page spreadsheet on a PC and
it prints fine. When I print it on the Mac equipped with the latest
Office for Mac (2004) the data does not line up with the columns and
the last column partially prints right of the cells. I think the

A workbook has some live links, but now when I put a website in, it does not
make a live link, did I disable it or what? Thanks.
OS 10.4.7
Office 2004

Anyone else having this issue?  Over time of repeated use Excel starts
opening workbooks that, yes were being worked on recently but were
closed before Excel was quit.  The only way I can get it to stop
opening the workbooks is to trash the preferences.  Anyone else getting

Is there a Seagate Crystal Reports (version 10) add-in for MS OFFICE EXCEL
2003?
Is there a download?

I am currently working on updating a huge spreadsheet from several
smaller ones.  All of a sudden, the large spreadsheet changed all of
the dates in M/DD/YY format to a five digit number.  If I double click
on the cell, it will show me the original date that was typed in, but

Can a logical statement invoke a macro?  If so how can you do it?

I'm wondering if there's a way to color every other line with a slight
grey color, using Normal view, in such a way that even if you Sort the
data on those lines, the grey banding still remains where they are. I
want to do this to produce an more readable document.

I am looking for a program to carry out Monte Carlo simulations on the
Mac. I have previously used @risk but this does not appear to support
the Mac version of Excel.
Any suggestions, other than RiskSim, for products?

Hello.  Basically what I'm trying to do is have Excel complete the
list for me.  For example, I am trying to catalog an office full of
CD's starting with the # 1000, then 1001, then 1002, etc.  Do I have
to type all of these in because there are hundreds of them, or can

Am running 10.4.8 and all the latest Office updates. I'm tired of Excel
either crashing or refusing to save data that has been entered. This has
happened several times  lately. At least the last time I could take a screen
shot to re-enter the data manually later.

Questions!
How do we change:
1)the size, the font size and the color of worksheet tabs without
changing the worksheet size?

How can I start a new line in the same cell? (it is ALT+ENTER for PC
version of Excel, but how can I do it on Mac?)

How do I match one data from one spreadsheet (A) with another (B) row
by row and then delete on spreadsheet (A) the data row that matches a
row from two columns in spreadsheet B?
catlair