info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
"manual" link option (in Excel) greyed out
1,986 views
Skip to first unread message
John Grattan
Jan 26, 2003, 3:08:31 PM1/26/03
to
I want to lock up the values of linked cells in an Excel
worksheet so that they don't update any more. "HELP"
tells me to just select 'manual' rather than 'automatic'
under Edit-Links. Problem is that the 'manual' option is
greyed out and can't be selected. I'm running Excel 97 on
Windows XP-home, both as received from Gateway recently.
Thanks much for any help!
worksheet so that they don't update any more. "HELP"
tells me to just select 'manual' rather than 'automatic'
under Edit-Links. Problem is that the 'manual' option is
greyed out and can't be selected. I'm running Excel 97 on
Windows XP-home, both as received from Gateway recently.
Thanks much for any help!
Bill Manville
Jan 26, 2003, 7:48:37 PM1/26/03
to
John Grattan wrote:
> I want to lock up the values of linked cells in an Excel
> worksheet so that they don't update any more. "HELP"
> tells me to just select 'manual' rather than 'automatic'
> under Edit-Links
>
Excel formula links are always automatic.> I want to lock up the values of linked cells in an Excel
> worksheet so that they don't update any more. "HELP"
> tells me to just select 'manual' rather than 'automatic'
> under Edit-Links
>
If you don't mind losing the formulas, Edit / Copy; Edit / Paste
Special / Values.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Donna
Jan 29, 2003, 9:23:22 AM1/29/03
to
>John....you don't have to change all your formulas to
values, go to Tools, Options, select the Calculation tab,
at the bottom for "Workbook Options" uncheck "Update
Remote References". This will effect the automatic
updating of "ALL" workbooks with links. You can then
update them manually by going to the Edit, Links, Update
Now. Hope this helps.
Bill Manville
Jan 29, 2003, 11:07:45 AM1/29/03
to
Donna wrote:
> you don't have to change all your formulas to
> values, go to Tools, Options, select the Calculation tab,
> at the bottom for "Workbook Options" uncheck "Update
> Remote References". This will effect the automatic
> updating of "ALL" workbooks with links.
>
> you don't have to change all your formulas to
> values, go to Tools, Options, select the Calculation tab,
> at the bottom for "Workbook Options" uncheck "Update
> Remote References". This will effect the automatic
> updating of "ALL" workbooks with links.
>
Would you like to put money on that?
I believe that inter-workbook links are not "remote references" but
"external references". "Remote references" are, I believe, links to
data provided by other programs. It is a per-workbook option.
Tools / Options / Edit / Ask to Update Automatic Links, on the other
hand, is an application-level option and applies to all workbooks with
links. HOwever, it results in links always being updated when you open
workbooks instead of giving you the dialog asking whether you want to
do this - so is the opposite of what is required here.
faram...@gmail.com
Jun 14, 2017, 7:40:12 PM6/14/17
to
Hey Bill, I come from the future (2017), I just want to let you know that even today I struggle with the same problem you had in 2003. Were you able to find a solution?
JonBit
Jun 30, 2017, 10:48:15 AM6/30/17
to
Sivah Akash
Oct 29, 2021, 8:39:07 PM10/29/21
to
0 new messages