Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes when opening file
I have a vital file which has begun to cause Excel to crash when I attempt to
open it. I made a change to a links source before this so I suspect this is a cause of the problem. Is there a way to word the "Workbooks.Open..." cose to open in "safe" mode? -- Best wishes, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes when opening file
there is no safe mode, but you can specify not to update links.
workbooks.open filename, UpdateLinks:=0 -- Regards, Tom Ogilvy "Jim Jackson" wrote: I have a vital file which has begun to cause Excel to crash when I attempt to open it. I made a change to a links source before this so I suspect this is a cause of the problem. Is there a way to word the "Workbooks.Open..." cose to open in "safe" mode? -- Best wishes, Jim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes when opening file
Thanks, Tom. That didn't work either. I finally copied the file and pasted,
changing "xls" to "csv", opened it and saved as "xls". All this happened in concert with some Server problems I was having and the resolution of tnose so it is possible the two were related. -- Best wishes, Jim "Tom Ogilvy" wrote: there is no safe mode, but you can specify not to update links. workbooks.open filename, UpdateLinks:=0 -- Regards, Tom Ogilvy "Jim Jackson" wrote: I have a vital file which has begun to cause Excel to crash when I attempt to open it. I made a change to a links source before this so I suspect this is a cause of the problem. Is there a way to word the "Workbooks.Open..." cose to open in "safe" mode? -- Best wishes, Jim |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes when opening file
Well, if it was actually a CSV file, then it can't contain links.
-- Regards, Tom Ogilvy "Jim Jackson" wrote in message ... Thanks, Tom. That didn't work either. I finally copied the file and pasted, changing "xls" to "csv", opened it and saved as "xls". All this happened in concert with some Server problems I was having and the resolution of tnose so it is possible the two were related. -- Best wishes, Jim "Tom Ogilvy" wrote: there is no safe mode, but you can specify not to update links. workbooks.open filename, UpdateLinks:=0 -- Regards, Tom Ogilvy "Jim Jackson" wrote: I have a vital file which has begun to cause Excel to crash when I attempt to open it. I made a change to a links source before this so I suspect this is a cause of the problem. Is there a way to word the "Workbooks.Open..." cose to open in "safe" mode? -- Best wishes, Jim |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes when opening file
True, but the easiest part is the re-establishment of links after recovering
the file and vital data. :) Now if I could just get my home ISP to be more dependable. :( -- Best wishes, Jim "Tom Ogilvy" wrote: Well, if it was actually a CSV file, then it can't contain links. -- Regards, Tom Ogilvy "Jim Jackson" wrote in message ... Thanks, Tom. That didn't work either. I finally copied the file and pasted, changing "xls" to "csv", opened it and saved as "xls". All this happened in concert with some Server problems I was having and the resolution of tnose so it is possible the two were related. -- Best wishes, Jim "Tom Ogilvy" wrote: there is no safe mode, but you can specify not to update links. workbooks.open filename, UpdateLinks:=0 -- Regards, Tom Ogilvy "Jim Jackson" wrote: I have a vital file which has begun to cause Excel to crash when I attempt to open it. I made a change to a links source before this so I suspect this is a cause of the problem. Is there a way to word the "Workbooks.Open..." cose to open in "safe" mode? -- Best wishes, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 | Excel Discussion (Misc queries) | |||
Excel crashes on opening exported file; formatting weird afterwards | Excel Discussion (Misc queries) | |||
Excel 2003 crashes when opening a file from one particular user | Excel Discussion (Misc queries) | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Excel 2003 crashes when opening | Excel Discussion (Misc queries) |