L
Larry Peng
Current System config:
Excel 10.1.4 (meaning that I have the 10.1.4 update installed)
OSX 10.2.6
784 MB RAM
16 GB free disk space (according to the Finder)
Single partition, all files and apps in their default locations
Problem:
Excel X consistently crashes when we try to open up documents which
have embedded links or macros.
We get the warning about enabling macros or whether to update the
links. It does not matter whether we say yes or no.
On one example with embedded links we have a workbook with 7 sheets.
Sheet one has an excel chart embedded into a spreadsheet. Excel bombs
every time this sheet is opened.
Files which show the macro warning almost always bomb Excel on telling
the program to open the file.
Files in which you try to use your personal macro workbook almost
routinely bomb Excel, except for a very strict procedure of setting up
you excel files to run the macros. Any deviance, and it is a
guaranteed bomb. In this case, the macros I believe have been carried
over from Excel 4. The person who created them is long gone.
The Excel files have come from other folks, but I cannot tell you any
specific config info. Other people on Wintel and Mac.
What has been tried so far:
Run Font Doctor on all OS 9 and OS X font locations. Says everything
is good.
Reinstall office from scratch tossing all preferences. Problem still
there.
Reinstalled entire OS and office from scratch. Problem still there.
Checked all permissions. Problem still there.
Disk Integrity and file system integrity checks. Problem still there
The old MS World solution of importing/cutting/pasting info into new
Excel document. Problem still there.
Temporary workaround (not good but tolerable for very short term):
Run Excel 2001 in Classic for these kind of Excel files.
Anybody have a clue. These are all the kinds of issues and annoyances
I had with Office 4.2 on the Mac and with Office 95 on Wintel. I
hated them then, and I am not happy now. There are some other
somewhat less pressing problems with Excel, such as pivot tables.
There are a lot of other problems especially with Word, but that is a
different post.
Thanks in advance.
Larry Peng
Lawrence Livermore National Lab
Excel 10.1.4 (meaning that I have the 10.1.4 update installed)
OSX 10.2.6
784 MB RAM
16 GB free disk space (according to the Finder)
Single partition, all files and apps in their default locations
Problem:
Excel X consistently crashes when we try to open up documents which
have embedded links or macros.
We get the warning about enabling macros or whether to update the
links. It does not matter whether we say yes or no.
On one example with embedded links we have a workbook with 7 sheets.
Sheet one has an excel chart embedded into a spreadsheet. Excel bombs
every time this sheet is opened.
Files which show the macro warning almost always bomb Excel on telling
the program to open the file.
Files in which you try to use your personal macro workbook almost
routinely bomb Excel, except for a very strict procedure of setting up
you excel files to run the macros. Any deviance, and it is a
guaranteed bomb. In this case, the macros I believe have been carried
over from Excel 4. The person who created them is long gone.
The Excel files have come from other folks, but I cannot tell you any
specific config info. Other people on Wintel and Mac.
What has been tried so far:
Run Font Doctor on all OS 9 and OS X font locations. Says everything
is good.
Reinstall office from scratch tossing all preferences. Problem still
there.
Reinstalled entire OS and office from scratch. Problem still there.
Checked all permissions. Problem still there.
Disk Integrity and file system integrity checks. Problem still there
The old MS World solution of importing/cutting/pasting info into new
Excel document. Problem still there.
Temporary workaround (not good but tolerable for very short term):
Run Excel 2001 in Classic for these kind of Excel files.
Anybody have a clue. These are all the kinds of issues and annoyances
I had with Office 4.2 on the Mac and with Office 95 on Wintel. I
hated them then, and I am not happy now. There are some other
somewhat less pressing problems with Excel, such as pivot tables.
There are a lot of other problems especially with Word, but that is a
different post.
Thanks in advance.
Larry Peng
Lawrence Livermore National Lab