Open file, save file, file now 120K smaller and crashes upon open

[Chris]

Hi,

Working with an Excel 2002 application that includes VB
and a number of calculations. File size of known good
copy is 4,680,192 bytes. If I open this file, click save
as.. and save the file, the file is now 4,565,504 bytes.
No modifications were made to the file. If I try to open
this newly created file it crashes Excel after prompting
to enable Macros (Security set to Medium). This occurs on
multiple PCs with same Office image.

Believe the problem is with the contents of the file but
not sure what to try changing. Any ideas.

Thanks,

Chris

 

[Grey Newt]

Open the file whilst disabling macros (finger of shift) - then go into VBA and see if there are any workbook open event procedures that fire upon opening - or maybe some older-style auto-open macros. Put a break in and see what happens.

Failing that - open it in Excel XP - this often opens a duff workbook. Check your macros for typical errors like a variable names being defined twice - I've seen this cause exactly that