XL office 2007 file to large

  • Thread starter Thread starter Darwinwins
  • Start date Start date
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.
 
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
 
Back
Top