Software

Ask something
Discussion Locked

Excel file size

0 helpful
5 replies

by stuart.truman

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I have been working on Excel worksheets developed in version 97 in Excel 2000. We have noticed a problem when the file has been saved in 2000 format with a file size of 2.69MB. When we then try to open this file in version 97 we receive a 'Not enough Memory error' on the same PC!. We have also noticed that the file sizes are very different in two files that contain basically the same data, graphics, charts etc from 2.69 MB to 1.59 MB. Plus the 1.59 MB file when saved in 2000 will open in 97. We need the sheets to work in 97 as our dealerships use version 97.

5 replies

by pan 13 x

when working with two versions of office , 2000 can open 97 objects but 97 can not ever open 2000 with out blowing up. It doesn't understand how to convert the data.
I would recommand you keep 97 on the computer needing this file or upgrade all to 2000. If you keep everything in 97 format and never save it in 2000 format you should be fine, but I would still recommend upgrading to 2000 still.

by sankulpune

Hello stuart,

You can open the same file in both (97 and 2000) the versions of Excel provided that you 'save as' the file using the
'Microsoft Excel 97-2000 & 5.0/95 Workbook (*.xls)' save as type while saving the file in Excel 2000.

It doesnot matter if once in a while you forget to do that. You can open any file any time and 'save as' in different format.

As a matter of safety though, I would recommend the file be backed up as frequently as possible.

Hope this helps.

I would, however, be glad to provide any more assistance you may need in this regard.

SanganakSakha,
Simple And Effective Answers To Small Problems, No QuickFixes

This discussion is closed to new replies.