I just had this problem for the first time yesterday. [After it happened
once, I thought it was because Excel itself had crashed, so I redid
everything and saved to NEW files every few steps. Unfortunately only the
first file is still readable; rest have the error message listed by the
original poster.] Started googling and digging around on the forums about
this and found I'm not the only one.
My question is: does anyone know if this problem has been resolved in
Service Pack 1? I've installed it on one of the three macs I use (all
Leopard now) but not the one I was using at home when the problem occurred.
I know I read of at least one person actually having problems with SP1, so
am a little hesitant to just go install it, especially if this problem
isn't solved. I looked on the page listing what had been fixed, but didn't
find anything that looked like this problem (could have missed it, of
course).
FWIW, (sounds similar to what others have seen) the problem appears to
have occurred after adding a pivot table to a file that already had >100K
lines (and many columns) of data (the pivot table references all 100+K
lines and all columns). I really don't want to go back to the previous
Excel, because it will be much more difficult to deal with the data in
pieces. (I was so excited to get the new Office/Excel because it could go
over 65someoddK lines!) My 100K line file before pivot table still seems
ok.
Also FWIW, I do have access at work tomorrow to Excel on Windows (via
Parallels on work mac), which I believe is 2007; I think I read in a
different thread that the files can be repaired there, so I may try that
(unless it can't do 100+K lines?). But I create these pivot tables (and do
a bunch of further things with the results) very frequently in this stage
of my project, so I really need to be able to save the files, and don't
want to use the Windows version (don't have it at home, anyway).
If it's NOT fixed yet: Pat McMillan, I've seen you ask others for files; I
won't bother you with one unless you need a new example but I've got plenty
to share if you need one. (They *are* 24M and above in size, so not sure
*how* I'd send it, even zipped...) (I'll try to watch here for an answer)
Thanks! Carolyn
|
