Hi,
I'm using MS Office 2007 (Excel 2007) SP1, and Windows XP SP2, mostly not patched since patches are made by the administrator.
On another machine I'm using Vista and Office 2007 (Excel 2007), fully patched.
I have a table with few web queries, few named ranges that copy-paste data on four sheets and do some cell manipulation (replace, change formats, delete, calculate few values). I already made this table few months ago but due to data loss had to build it again. It looks better but it doesn't work. First, after ten runs of this thing my MS Exce became sluggish, it takes half a minute to open, same with MS Word. The file with which it began and that is crashing Excel all the time takes more than a minute to open (it used to take more than five minutes but I made a new file which wasn't burdened by unused web queries).
Last thing that happened is that after resizing a column and starting a macro I got the following error (on both configuration crashes the same way):
AppName: excel.exe AppVer: 12.0.4518.1014 AppStamp:45428263
ModName: vbe6.dll ModVer: 6.5.10.20 ModStamp:45187577
fDebug: 0 Offset: 001a5cc9
What can I do to solve it?
How can I diagnose the potential problem?
Thank you in advance,
Marin
I'm using MS Office 2007 (Excel 2007) SP1, and Windows XP SP2, mostly not patched since patches are made by the administrator.
On another machine I'm using Vista and Office 2007 (Excel 2007), fully patched.
I have a table with few web queries, few named ranges that copy-paste data on four sheets and do some cell manipulation (replace, change formats, delete, calculate few values). I already made this table few months ago but due to data loss had to build it again. It looks better but it doesn't work. First, after ten runs of this thing my MS Exce became sluggish, it takes half a minute to open, same with MS Word. The file with which it began and that is crashing Excel all the time takes more than a minute to open (it used to take more than five minutes but I made a new file which wasn't burdened by unused web queries).
Last thing that happened is that after resizing a column and starting a macro I got the following error (on both configuration crashes the same way):
AppName: excel.exe AppVer: 12.0.4518.1014 AppStamp:45428263
ModName: vbe6.dll ModVer: 6.5.10.20 ModStamp:45187577
fDebug: 0 Offset: 001a5cc9
What can I do to solve it?
How can I diagnose the potential problem?
Thank you in advance,
Marin