Excel manual update links greyed out

 · posted May, am AEST. O.P. I need to update a master spreadsheet which contains links to source files that are going to be moved to a server. This should be a simple thing to do through the menu with "edit link" and "Change source" but the "Change Source" button is greyed out and can't be used. A search on the web did not come up with an .  · Edit links as far as i am aware is available only if there is already a link in the file. The main file is in the book called Master in which the edit links is grayed out and NOT protected. It was protected so I removed the protection. However, .  · Here's one reason that Edit Links could be grayed out: Edit Links pays attention only to formulas in cells, not to range names. So if you have range names linked to the other workbook but you have no formulas in cells that are using those names, then Edit Links will be grayed out. To correct the problem, just enter a formula like =MyName, where MyName is a .

Under Edit Links, Startup Prompt: Let users choose to display the alert or not. Trust Center settings, External Content: Prompt user on automatic update for. Workbook Links. Excel Options, Advanced, General: Ask to update automatic links. Also, on the "Edit Links" panel, the "Manual" Update option is grayed out, and: In the Excel Options. 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. Method 2: Disable Update Links by Excel Option. Step 1: Click File in ribbon, and select ' Options ' in menu. Step 2: In Excel Options window, click Advanced in left panel. Step 3: Drag scroll bar till General options are displayed. ' Ask to update automatic links' is checked by default. Uncheck it and click OK to save operating.

Here's one reason that Edit Links could be grayed out: Edit Links pays attention only to formulas in cells, not to range names. So if you have range names linked to the other workbook but you have no formulas in cells that are using those names, then Edit Links will be grayed out. To correct the problem, just enter a formula like =MyName, where. Excel Options, Advanced, General: Ask to update automatic links. Also, on the “Edit Links” panel, the “Manual” Update option is grayed out, Excel edit links manually greyed out by iznffcx Note In Excel /, click Edit Links in the Connections Originally i wanted to use the tells me to just select ‘manual’ rather. Go to File Options Advanced. Under General, clear the Ask to update automatic links check box. If this check box is cleared, the links are automatically updated, and no alert is displayed. Prompt in the same way for every user of this workbook. Warning: This option affects all users of the workbook.