Excel Add-In and File Size

  • Thread starter Thread starter mah_kum_70
  • Start date Start date
M

mah_kum_70

Hi,

I have an Excel Add-In with Macros in it. I open the Addin, enter some
data and save the Sheet which saves it as .xls file. However, the file
size becomes very large eventhough the Sheet has only 4 lines.

What is the reason? Is the macro getting SAVEed also? I opened the .xls
file and looked at the macros. Nothing there.

Where should I look?

Any help is appreciated.

thanks
 
You could try Ctrl > End and see where XL thinks the last used cell is, then
find you're actual last used cell. DELETE ( not clear contents) all rows and
columns after your actual used cell, save the file, exit, and go back into
it, see what size is then,
Regards,
Alan
 
Back
Top