File size keeps multiplying

L

laurap

I manage an Excel file in MS 2003 on a weekly basis. I receive the file from
another person, make modifications by copying and pasting text from multiple
people, and send the file back out to a distribution list. For the past
three weeks, the file is doubling in size. The first week I saved it, it was
1.3MB, the next week it grew to 2.3MB, the next 4.3MB, and finally 8.6MB.
There are no text boxes, and no extra rows. There is only one tab, and
printed the whole file is only two pages - with no pictures or highlighting -
just text and some borders. I can't figure out what is causing this. I
cleared out the clipboard, and that had no effect. I have maintained this
file for several years, and never experienced this issue. The only feedback
I have received from someone on the distribution list, is that it's coming
through as an .rtf file - though it saves to my hard drive and attaches to
the e-mail as an .xls file. Any ideas what is causing this issue, and how it
can be fixed?
 
K

Ken Wright

Try Edit / Go To Special / Objects, just to be sure there are no hidden
graphics in hidden rows that are now getting copied in or something like
that.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
P

Pete_UK

With you repeatedly copying and pasting data, you might have set the
last cell to somewhere beyond your data - do CTRL-END and see where the
cursor moves to. If this is way beyond your data, you should highlight
the blank rows and Edit | Delete (don't just delete the contents) and
similarly with the blank columns. When you save the file it should
recover this "lost" memory.

It's also worthwhile checking to see if you have any redundant named
ranges - do Insert | Name | Define and check through the list presented
to you, deleting any that are no longer needed.

Hope this helps.

Pete
 
D

David McRitchie

Hi Laura,
If it is an Excel file everyone should be using Excel.
The use of .rtf (Rich Text File) extension is very suspicious,
almost seems like you might have some people using, Word,
HTML, Front Page. You could have serious problems with
"Round Tripping" see my slowresp.htm page.

Saving an Excel as compatible will essentially save two versions
of a file, very unlikely that you would want to do that. (slowresp.htm page)


Lastcell problems:
Last cell was mentioned check that with Ctrl+End which should
be the intersection of the last used column and last used row.
Caused by inserting/deleting rows/columns

to fix an entire workbook suggest the macro at Debra Dalgleish's page
Why do my scrollbars go to row 500 -- my data ends in cell E50?,
http://www.contextures.com/xlfaqApp.html#Unused
 
Top