XL office 2007 file to large

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darwinwins - 07 May 2008 19:30 GMT

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.

Reply to this Message

Peo Sjoblom - 07 May 2008 21:16 GMT

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

Signature

Regards,

Peo Sjoblom

>I recently created a *relatively large file in excel 2007 and when I tried
>to
[quoted text clipped - 7 lines]
> evidently true. Is there anything I can do to save the entire file as a
> single 97-2003 workbook without losing anything? Thank you.

Reply to this Message