Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wits end wrt automatic linking
Hi folks, as the subject says I'm at my wits end with regards to
automatic linking. I am using sheets from an old workbook in a new workbook and I can't seem to find any more external links to delete, yet Excel 2010 still gives me the yellow ribbon that says "Automatic update of links has been disabled" on startup. I have searched for [ and ], c:\, ref, name, value... Can't seem to find the culprit. Can anyone lend a hand? I have to distribute this file and I don't want that ribbon showing up for everyone. Thanks, Craig |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wits end wrt automatic linking
Have a look for links in Defined Names.
Gord Dibben MS Excel MVP On Fri, 8 Apr 2011 05:38:11 -0700 (PDT), TheMilkGuy wrote: Hi folks, as the subject says I'm at my wits end with regards to automatic linking. I am using sheets from an old workbook in a new workbook and I can't seem to find any more external links to delete, yet Excel 2010 still gives me the yellow ribbon that says "Automatic update of links has been disabled" on startup. I have searched for [ and ], c:\, ref, name, value... Can't seem to find the culprit. Can anyone lend a hand? I have to distribute this file and I don't want that ribbon showing up for everyone. Thanks, Craig |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wits end wrt automatic linking
Thanks for the suggestion Gord, I forgot to mention in my original
post that I have checked the Defined Names already. Sorry. Thank you, though! C On Apr 8, 12:16*pm, Gord Dibben wrote: Have a look for links in Defined Names. Gord Dibben * * MS Excel MVP On Fri, 8 Apr 2011 05:38:11 -0700 (PDT), TheMilkGuy wrote: Hi folks, as the subject says I'm at my wits end with regards to automatic linking. I am using sheets from an old workbook in a new workbook and I can't seem to find any more external links to delete, yet Excel 2010 still gives me the yellow ribbon that says "Automatic update of links has been disabled" on startup. I have searched for [ and ], c:\, ref, name, value... *Can't seem to find the culprit. Can anyone lend a hand? *I have to distribute this file and I don't want that ribbon showing up for everyone. Thanks, Craig |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wits end wrt automatic linking
Solved the issue (I think) by "breaking the link" in the Data-
Connections tab. Not much info given as to where the link was located in my current workbook, but at least I was able to get rid of the yellow bar on start. Cheers, Craig On Apr 8, 12:28*pm, TheMilkGuy wrote: Thanks for the suggestion Gord, I forgot to mention in my original post that I have checked the Defined Names already. *Sorry. Thank you, though! C On Apr 8, 12:16*pm, Gord Dibben wrote: Have a look for links in Defined Names. Gord Dibben * * MS Excel MVP On Fri, 8 Apr 2011 05:38:11 -0700 (PDT), TheMilkGuy wrote: Hi folks, as the subject says I'm at my wits end with regards to automatic linking. I am using sheets from an old workbook in a new workbook and I can't seem to find any more external links to delete, yet Excel 2010 still gives me the yellow ribbon that says "Automatic update of links has been disabled" on startup. I have searched for [ and ], c:\, ref, name, value... *Can't seem to find the culprit. Can anyone lend a hand? *I have to distribute this file and I don't want that ribbon showing up for everyone. Thanks, Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object linking/Worsksheet linking/etc... | Excel Discussion (Misc queries) | |||
Linking choices in drop down menu to have automatic answer... | Excel Discussion (Misc queries) | |||
An error msg in Excel 2007 regarding Linking but no linking in fil | Excel Discussion (Misc queries) | |||
Text to rows...at wits end | Excel Worksheet Functions | |||
Linking data between columns in an automatic way with dynamic link | Excel Discussion (Misc queries) |