Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 128
Default Can Breaking Links Corrupt Excel File

I had links to spreadsheet charts in a word doc that were causing huge delays
in opening the word doc so I removed the links just by selecting and deleting
them. I later found the Excel workbook to be corrupted and won't open
anymore. Could this have caused the problem and does this suggest a
workaround to open the Excel file.
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default Can Breaking Links Corrupt Excel File

Could it have caused the problem - yes, but that's not saying that it
absolutely did cause it.

As for a future workaround, look at Tools -- Options -- Edit tab and check
the box labeled "Ask to update automatic links". This will then display a
message that lets you confirm the update before it's done. I believe this is
workbook specific, so you'd have to do this for any workbooks you don't want
to update without checking with you first.


"Kris" wrote:

I had links to spreadsheet charts in a word doc that were causing huge delays
in opening the word doc so I removed the links just by selecting and deleting
them. I later found the Excel workbook to be corrupted and won't open
anymore. Could this have caused the problem and does this suggest a
workaround to open the Excel file.
Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 128
Default Can Breaking Links Corrupt Excel File

Thanks. Kris

"JLatham" wrote:

Could it have caused the problem - yes, but that's not saying that it
absolutely did cause it.

As for a future workaround, look at Tools -- Options -- Edit tab and check
the box labeled "Ask to update automatic links". This will then display a
message that lets you confirm the update before it's done. I believe this is
workbook specific, so you'd have to do this for any workbooks you don't want
to update without checking with you first.


"Kris" wrote:

I had links to spreadsheet charts in a word doc that were causing huge delays
in opening the word doc so I removed the links just by selecting and deleting
them. I later found the Excel workbook to be corrupted and won't open
anymore. Could this have caused the problem and does this suggest a
workaround to open the Excel file.
Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 07 breaking links LisaK Links and Linking in Excel 11 January 6th 10 06:11 PM
Breaking links in Excel brosull Excel Worksheet Functions 2 June 29th 09 09:38 PM
How to see the correct information from file without breaking links [email protected] Links and Linking in Excel 1 August 19th 07 10:55 PM
breaking links between excel files when one file already deleted? tweekgirl27 Excel Worksheet Functions 0 August 11th 06 05:47 PM
Breaking Links in Excel 2000 Nevio Excel Discussion (Misc queries) 2 August 17th 05 01:26 PM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"