Software

Ask something
Discussion Locked

excel97 and files

0 helpful
6 replies

by zlitocook

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
when we create an excel worksheet its starts out about 47kb but the size increases to over 1 meg by itself. we use no macros or popups its a simple form for users to use as a template. on a win95 workstation. over an nt network.

6 replies

by dklippert

First, make sure the file was saved in "Microsoft Excel Workbook" format, and not "5.0/95 & 97" format, which increases the size.

Press Ctrl-End. This will move the cell pointer to the last 'used' cell. If the address of the last cell is far below the last cell containing data, you should delete those empty columns/rows to reduce file size

If you need to reset the last cell, there is a neat macro at this location:

http://j-walk.com/ss/excel/tips/tip73.htm

(There are no spaces in the URL)

by zlitocook

They are saved as a workbook and it is only two pages long. No extra cells or rows. One this week was over 2meg! What a stumper.

by dklippert

These problems are always difficult, because the formatting on distant cells can be subtle.
Good luck to you and your people.

This discussion is closed to new replies.