This isn't a "prgramming" question, but I don't think there is a NG specific
to my question, and the people on this thread seem to be quite knowledgable
about all things Excel. </suck-up

I've got two different Excel files. They are very nearly identical. Without
going into detail, they are production tracking forms. They each have four
worksheets with links among the sheets. I have data validation pointing to a
specific range on the "main sheet" that dynamically populates dropdown boxes
on two other sheets. I do have to use volatile functions for this.

Neither form contains macros. To the best of my knowledge, neither of them
EVER contained macros.

The only appreciable difference between the two files is that the "man
sheet" on one of the files contains more columns of data entry. (The bulk the
of sheet is locked and protected; only the places where users can type are
editable. One of the forms has more of these editable areas - which users
just type in a whole number between 1 and 50.)

However, one of the forms in 980K. The other is 2 MB. What's most vexing is
the one that contains "more" stuff in it is the smaller of the two. Does
anyone have any idea how the file could have ballooned like that? Does Excel
offer any sort of "compact and repair" function like Access does. I can tell
you that both files have undergone a lot of radical modifications - but
identical ones. (In fact, I usually make the changes to one, then simply copy
the changed sheet to the other.)

Thanks for your help!

--
Hmm...they have the Internet on COMPUTERS now!