Excel 2007 not saving workbook

[phillfri]

Sometimes Excel 2007 doesn't save workbook changes and on two occasions my original workbook was gone from my hard drive after closing the workbook, nor were any Excel backup files to be found in any of the usual locations. Nor am I always getting warnings on closing a workbook that there are unsaved changes. To make sure things were getting saved I added the following code to the Workbook_BeforeClose event:

Please Login or Register  to view this content.

The msgbox never pops up so I'm assuming the ThisWorkBook.saved property is indicating there are no changes to be saved.

I am developing vba code for a tracking workbook and a part of that code copies a "master worksheet" to a "new worksheet" inside the workbook. Usually a few times during a session. Today during testing I had copied two worksheets from the master worksheet and entered data in them. I closed the workbook, but when I reopened it later, the two worksheets were not there. I did find a Microsoft KB note about issues with copying worksheets in the same workbook http://support.microsoft.com/kb/210684, but I am not getting the indicated error message.

If anyone has experienced anything that might give me a clue what the problem might be I'd be appreciative. At this point I'm pulling my hair out. I'm not having any problems with my VBA code actually working.

Environment:
Business Workstation: Excel 2007, Windows XP SP3, corporate networked machine
Laptop Workstation: Excel 2010, Windows 8, home network
Workbook is being saved to a portable USB device.
The problem does not happen on the laptop with Excel 2010.

[TMS]

Try putting a Stop as the first line in the Workbook Before Close event handler. Then close the workbook. If the code doesn't break on the Stop, the Before Close event hasn't been fired. That could mean Event handling is turned off. If that is the case, switch it back on and try again.


Regards, TMS