Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File not opening
Hi,
I'm using Excel 2000. I have a huge excel file of over 4MB in size with links to other files. When I'm trying to open this file, it shows the prompt - to select "Yes" or "No" - for whether I want to update the links or not. As soon as , I click Yes or No, it shows an error message that "Excel caused some error and closing the program". I'd faced similar issues earlier sometime back and sought help here. At that time, the file was without links to other files and on opening there was no prompt like this time. That time, I was advised to save the file as Microsoft Excel 95 and it worked. However, this time, it is not allowing me to save that file as Microsoft 95 as be default that prompt pops up and I can't proceed further unless I click Yes or No. Any suggestions will be greatly appreciated. Thanks, Manish Bajpai |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File not opening
Make a back up copy of the file by copying it with Windows explorer, then do
your work on the copy: Try opening it with code sub OpenMyfile() Workbooks.Open "C:\Myfolder\MYFile.xls", UpdateLinks:=0 End sub then, if successful, try to clean up or remove your links, or copy out what you need. -- Regards, Tom Ogilvy "Manish Bajpai" wrote in message ... Hi, I'm using Excel 2000. I have a huge excel file of over 4MB in size with links to other files. When I'm trying to open this file, it shows the prompt - to select "Yes" or "No" - for whether I want to update the links or not. As soon as , I click Yes or No, it shows an error message that "Excel caused some error and closing the program". I'd faced similar issues earlier sometime back and sought help here. At that time, the file was without links to other files and on opening there was no prompt like this time. That time, I was advised to save the file as Microsoft Excel 95 and it worked. However, this time, it is not allowing me to save that file as Microsoft 95 as be default that prompt pops up and I can't proceed further unless I click Yes or No. Any suggestions will be greatly appreciated. Thanks, Manish Bajpai |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Error:Invalid File format,while opening an Excel Template file | Excel Programming |