Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web queries crash excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web queries crash excel
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" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web queries crash excel
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" wrote: 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" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web queries crash excel
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" wrote: 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" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web queries crash excel
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). "joel" wrote: 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" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web queries crash excel
No that's not the case, it's saved as a 2007 file. Any other ideas?
"joel" wrote: 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). "joel" wrote: 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" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web queries crash excel
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" wrote: No that's not the case, it's saved as a 2007 file. Any other ideas? "joel" wrote: 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). "joel" wrote: 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" wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web queries crash excel
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" wrote: 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" wrote: No that's not the case, it's saved as a 2007 file. Any other ideas? "joel" wrote: 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). "joel" wrote: 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" wrote: 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web queries crash excel
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? "Shishir" wrote: 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" wrote: 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" wrote: No that's not the case, it's saved as a 2007 file. Any other ideas? "joel" wrote: 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). "joel" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 UDF crash | Excel Discussion (Misc queries) | |||
Excel chart crash | Charts and Charting in Excel | |||
password crash in excel | Excel Discussion (Misc queries) | |||
excel and word crash | Excel Worksheet Functions | |||
Excel Crash - Help! | Excel Discussion (Misc queries) |