Duplicate files - different sizes?

  • Thread starter Thread starter PCLIVE
  • Start date Start date
P

PCLIVE

I trying to figure out what is different between two files I have created.
I have two files that, as far as I can tell, are exactly the same. However,
one file is 1588 KB and the other is 4038 KB. I am the creator of both
files, but I can't find anything different with them. Each file has two
worksheets (none hidden). Sheet 2 is blank on both files. To be sure the
blank worksheets were the same, I copied one to the other and saved. The
file size differences stayed the same. Both files have the same exact
Macros and Modules. Sheet1 on both files looks the same. I've made sure
there was no miscellaneous garbage on these pages by highlighting all of the
blank sections, deleting them, and re-saving. Nothing changes. Does anyone
have any idea what could be causing my size difference?

Thanks,
Paul
 
Hi Paul,

Worth checking the used range: press ctrl-End on each sheet of the large
one.
This will show you where Excel thinks the bottom right cell of the used
range is.
If it is not where it should be you should delete all columns to the right
of your real last cell, and delete all rows below your real klast cell, and
then Save As.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
Thanks Charles, But I had already done that thinking there may be some
hidden data. I've also tried copying the two sheets from the smaller file
and pasting them to the larger file (overwriting the current sheets) and
then saving as a different file name. Nothing changed in the file size. I
also tried this in reverse and still nothing changed. There must be
something hidden in the coding for these two workbooks, but I've tried going
into the VBA Editor and could find nothing to substantiate 3 MB's worth of
data.

Any other Tips?
Thanks,
Paul
 
Back
Top