ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   links disabled ?? (https://www.excelbanter.com/excel-worksheet-functions/249224-links-disabled.html)

coltheplumb

links disabled ??
 
I have linked sheets in a workbook, when i go to edit a worksheet i get the
message to "edit worksheet" option come up as normal, but i also have "
links have been disabled" i then have to go into this and click on the allow
links before i can then go into edit the sheet!!! is there anyway of stopping
this happen ?. it is soooo anoying, if they give you the option to set up
worksheets with links then why do they then sod about n put the disabled
thing in the way GRRRRRRRRR. any help would be very much appriciated
cheers Colin x


ryguy7272

links disabled ??
 
To kill all links...Edit Links Break Links.

HTH,
Ryan-

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"coltheplumb" wrote:

I have linked sheets in a workbook, when i go to edit a worksheet i get the
message to "edit worksheet" option come up as normal, but i also have "
links have been disabled" i then have to go into this and click on the allow
links before i can then go into edit the sheet!!! is there anyway of stopping
this happen ?. it is soooo anoying, if they give you the option to set up
worksheets with links then why do they then sod about n put the disabled
thing in the way GRRRRRRRRR. any help would be very much appriciated
cheers Colin x


coltheplumb

links disabled ??
 
no thats not my problem ,i dont want to break the links i want to be able to
edit the sheets without first having to tell the system that i want to keep
the links !

"ryguy7272" wrote:

To kill all links...Edit Links Break Links.

HTH,
Ryan-

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"coltheplumb" wrote:

I have linked sheets in a workbook, when i go to edit a worksheet i get the
message to "edit worksheet" option come up as normal, but i also have "
links have been disabled" i then have to go into this and click on the allow
links before i can then go into edit the sheet!!! is there anyway of stopping
this happen ?. it is soooo anoying, if they give you the option to set up
worksheets with links then why do they then sod about n put the disabled
thing in the way GRRRRRRRRR. any help would be very much appriciated
cheers Colin x



All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com