I use excel 2007, I download data daily. 3 of the 13 worksheets in my workbook I use Macros. so my workbook is saved in Excel Macro-Enabled Workbook. I never had a problem before, but lately whenever I try to open the workbook it says not responding... when it does open I have no problem going from worksheet to worksheet or downloading the data or doing the macros in the 3 worksheets... but when I try to save a sheet or save the workbook, all I get is not responding and it takes from 1 to 3 minutes to save or close it.
I thought at first it was my memorey so I tranfered my workbook to a new laptop and it does the same thing. like I said never had a problem before, but now excell is taking a long time opening, saving and closing. the not responding shows up every time now. anyone know what causes this and how I can prevent this.
Bookmarks