Web queries crash excel

[Shishir]

Hi,

I'm on Excel 2007 and I have a excel file with quite a few web queries that
pull data from external websites - basically tables of financial data.

After opening the file, I'm able to work with the worksheet well enough and
refresh my data, but whenever I try to save the file or save as or the
auto-recover tries to save the file, excel just crashes. This happens even if
I just open the file and try to save a new version w/o making any changes, it
just doesn't save the file without crashing.

Any ideas what could be a solution?

Thanks,
Shishir

 

[joel]

I would try making a new workbook the follwing way

1) select all the tabs in the workbook

Select 1st tab and then scroll too last tab (first tabg still selected).
Hold the shift key and press the last tab. All the tabs are now selected.

2) Hold the mouse over any of the selected tabs and press right mouse key

3) Select Copy or move

4) Select Make a copy and then on the pull down (To book) sleect new workbook.

5) Save New workbook using SAVEAS.

This method will force excel to copy the data and eleiminatre any errors
that may be in the workbook. if you get an error using this method then you
workbook has an error that need to be fixed.

Try going to the follwing tool while the workbook is opened.

Start = Programs - Microsoft office - Microsoft Ofice Tools - Moicrtosoft
office Application Recovery

 

[Shishir]

Thanks for the response Joel. I tried doing what you told me and the new
workbook also crashed when I tried to save it.

Do you know what the problem might be with the web queries and how I can
find it? They are just simple queries that pull tables off a website. Why
would excel not be able to save a file because of that? They are not queries
that are supposed to auto-refresh.

Shishir

 

[Shishir]

Thanks for the response Joel. I tried doing what you told me and the new
workbook also crashed when I tried to save it.

Do you know what the problem might be with the web queries and how I can
find it? They are just simple queries that pull tables off a website. Why
would excel not be able to save a file because of that? They are not queries
that are supposed to auto-refresh.

Shishir

 

[joel]

One possibility is there are too many rows being returned. You could have a
XLS file type which limits the number of rows and columns. Try saving the
file using SAVEAS and select a file type other than XLS (one of the newer
2007 types).

 

[Shishir]

No that's not the case, it's saved as a 2007 file. Any other ideas?

 

[joel]

What I normally do under these conditions is to attempt to find out where the
problem is. make a copy of the workbook. then delete all the worksheets
except one and see if the problem occurs. find out if the problem is one one
worksheet all the worksheets. Then take the sheet where the problem is
occuring and start to delete rows and colums. Delete from rows 100 to end
and columns F to end. continue delting rows and columns in diffferent
combinations until you determine where the problem is located.

there may be something corrupted in the Access file and finding where the
problem is locoated will give you clues on how to fix the problem. Aslo make
sure you have all the updates from the microsoft website installed for both
Excel, Access, and XP/Vista.

 

[Shishir]

That was a good suggestion Joel. I started off by deleting every single sheet
that had any data on it and left a single blank sheet in the file, then tried
to save it and it STILL crashed haha.

I don't know where that leaves me!

Shishir

 

[joel]

Create a new workbook. Close all workbooks and then open Excel from Start
menu. Then perrform a SaveAs. Then open old workbook and right click one of
the tabs and perrform Move copy to new workbook created (like earlier). then
do another save on new workbook not saveas). it is possible that your
default save folder has too much data or too many folders. if you recently
upgraded to Vista/office 2007 you may ned to install more memory on your PC.
Does the problem happen on other PCs with the same file?