Maximum size depends on available memory, but 25 to 20 megs is too large. If this is just data Access would be the answer, but I?m guessing it?s too much formatting. One of the biggest causes of file bloat is excessive formatting. Many times people will format an entire row or column. That formatting bloats the size of a file.
Hit Ctrl+End. That will tell you which cell Excel thinks is the last used cell.
Go to the far right of the area that is used for data (in the first row). Go one morecell to the right and hit Ctrl+Shift+End. The whole empty area is now selected. Go to Edit>Clear All and remove all entries and formatting in that area.
Save the file and try Ctrl+End again.
Look at the area below the entered data. Choose an emptycell below entries and do the Ctrl+Shift+End trick again.
John Walkenbach has some code to reset the last cell:
j-walk.com/ss/excel/tips/tip73.htm
And MS has a Excess format cleaner that I have not tried. It?s called XSclean.exe. It?e mentioned in this file (ignore the title)
(Type the Q number in the search box at support.microsoft.com)
Large File Size After Saving WK4 File as Excel Workbook
Q123269
