Software

Ask something
Question Locked

Excel File Size in Question

0 helpful
2 replies

by rmathis

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Ok heres the thing I know it happens to alot of people and its been accuring alot as of late. Excel file will reach 1.5megs with little text in it form a file that starts at 42KB. It only happens on rare things. For example I might make something with 4 pages of text and still wont get that big then someone else dose something as simple as 3 lines and it grows rather large. Is there any reason for this the Office suites are setup the same no differance other then user accounts.

2 replies

by mduffy37

I have a similar problem. Text doesnt deserve such a file-size.

I've found that if file length grows from standard 100 lines long to 2500 lines, all of a sudden Excel feels obliged to save it as if 65000 lines of data have been entered.

This increases file size from 100KB to 13MB.

So write a program to delete range from line 100 to the end. Then re-save in smaller size!
Now save as 100KB again.

This discussion is closed to new replies.