> I had the same problem with very simple spreadsheet (no pivot tables,
etc.) that I saved with a .xlsx extension. It would not open. Just for fun
I changed the extension from .xlsx to .xls and voila it opened.
I tried that with mine (that solution was suggested in a different,
related thread) but that didn't work with my files.
An update: I have been retracing my steps from the beginning, saving to a
new file EVERY step along the way. For my data, at least, the problem
actually occurs BEFORE doing the pivot table, namely when I tried to sort
the data by columns (left to right). The data are 33 columns by >107K lines
long. I haven't tried to do the more normal sort to see if that also causes
problems, but will after I get back to Excel (it's giving me a totally
different problem right at the moment). (I haven't recreated everything I
did yet, like lots of graphs, so maybe the problem will recur with other
things too.)
Pat, as soon as I'm able I'll give you a more detailed account of what
I've been trying and what's been working and not, and as soon as I hear
back from the army guy (assuming it's ok) I'll send you the files (our
department maintains a file server with a public access location). But you
might want to see if the others re****ting this error message had also tried
just sorting their data at some point along the way in addition to making
pivot tables. Is this enough of a pointer to help this, or would files
still be useful?
(And I'm no longer dead in the water; sorting was helpful but not
necessary to my work :-). )
Thanks,
Carolyn
|
