Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
gpon
 
Posts: n/a
Default accessing & breaking links

I have templates which contain a data entry sheet linked to multiple
calculation & results sheets. The tech enters data for each unit into the
data sheet, views, prints & individually saves each unit's results sheet. I
need to break the links between the saved copy & data sheet.
Here are my problems:
I can't access the links dialog box from the linked sheets in the template.
If I could I would change the links to manual update.

I can't change the links to manual update from the copied sheets. The manual
option is unavailable.

Therefore if someone within the network opens, accidentally updates & saves
the individual (copied) file - the original data would be lost forever. I'm
sure it will happen eventually. Not to mention the annoyance & confusion
caused by the update links dialog box.
Thanks for help, advice or comments.
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
accessing & breaking links gpon Links and Linking in Excel 0 January 4th 06 10:11 PM
Still need help breaking links, but am sorry about the graphics thelees Excel Discussion (Misc queries) 15 September 25th 05 11:20 PM
Breaking Links thelees Excel Discussion (Misc queries) 1 September 24th 05 07:11 PM
Breaking Links tojo107 Excel Discussion (Misc queries) 2 July 20th 05 05:40 AM
Data Table - Graph Links Breaking!!! Geise, Brad Charts and Charting in Excel 1 March 31st 05 12:34 AM


All times are GMT +1. The time now is 07:04 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"