Without seeing the workbook, I couldn’t help you.
What do you mean by “forms”? A proper workbook should have the raw data separate from the presentation. Sounds like your data is mixed in with calculations, formatting, etc.
SbElectric (may be duplicate posting – I encountered outage during answer composition)
I am aware of “last cell” incident & the impact it has on large worksheet.
Here is a snipped:
Microsoft Excel saves only the part of each worksheet that is in use, meaning the section that contains data or formatting. Sometimes the last cell of a worksheet may be beyond the range of your actual used data. This issue may cause you to have a larger file size than neccesary, you may print extra pages, you may receive “Out of Memory” error messages, or you may experience other unusual behavior. Clearing the excess rows and columns to reset the last cell can help to resolve these issues.
You may browse: http://support.microsoft.com/kb/244435
Please let us know the final verdict – I will be curious.