XL office 2007 file to large

D

Darwinwins

I recently created a *relatively large file in excel 2007 and when I tried to
save it as a 97-2003 workbook I too was notified that data had been lost. The
difference being from what I have read here so far is that the alert message
I received informed me that anything after column IV (the original document
contains data up to and including column JO) was not saved and this was
evidently true. Is there anything I can do to save the entire file as a
single 97-2003 workbook without losing anything? Thank you.
 
P

Peo Sjoblom

You can portion out the file over multiple sheets and cut all data after
column IV
and paste it into another sheet, then save it in compatibility mode. That
goes for anything beyond 65536 rows as well since those are the limits of
97-2003 Excel


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top