links to other worksheets

linus50 · Mar 19th, 2002, 07:09 AM

I have a worksheet that previously had links to other worksheets, when the worksheet was opened it would ask the quesiton "... contains links, do you want to update now ..." (or something similar). The worksheet no longer has links, the cells are now used for direct inputs or formulas all referencing the opened worksheet. Is there away to have it stop asking the question when the worksheet is opened, (since there are no links)???

sax · Mar 19th, 2002, 07:23 AM

Hi,
easiest way is to copy that sheet and paste it in new one. Choose "Paste special"-Values and than "Paste special"-Formats.
This way you will remove links.
Hope this will help.
Sax

Russell · Mar 19th, 2002, 07:25 AM

You must still have links on the sheet. If you select Edit Links this will tell you the sheet you are linking to. You can then search for the first part of the filename e.g c:...
Have you got an hidden sheets containing a link?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 07:09 AM	#1
linus50 New Member Join Date: Mar 2002 Posts: 3	I have a worksheet that previously had links to other worksheets, when the worksheet was opened it would ask the quesiton "... contains links, do you want to update now ..." (or something similar). The worksheet no longer has links, the cells are now used for direct inputs or formulas all referencing the opened worksheet. Is there away to have it stop asking the question when the worksheet is opened, (since there are no links)???

Mar 19th, 2002, 07:23 AM	#2
sax Board Regular Join Date: Feb 2002 Location: Belgrade, Yugoslavia Posts: 148	Hi, easiest way is to copy that sheet and paste it in new one. Choose "Paste special"-Values and than "Paste special"-Formats. This way you will remove links. Hope this will help. Sax

Mar 19th, 2002, 07:25 AM	#3
Russell New Member Join Date: Mar 2002 Posts: 39	You must still have links on the sheet. If you select Edit Links this will tell you the sheet you are linking to. You can then search for the first part of the filename e.g c:... Have you got an hidden sheets containing a link?