Home |
Search |
Today's Posts |
#1
|
|||
|
|||
update links in an individual worksheet
Is it possible to update links in just one worksheet of a workbook? I
have a workbook with 12 worksheets, one sheet for each month, and would like to update the current months links instead of taking the time to update all of the worksheets. Thanks in advance for any help. |
#2
|
|||
|
|||
Is it possible to update links in just one worksheet of a workbook?
Not as far as I know. If the links are all in the same sheet, say "July" then you could do Edit / Replace / July [with] July / Replace All which I think would update the formulas Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Bill Manville wrote:
Is it possible to update links in just one worksheet of a workbook? Not as far as I know. If the links are all in the same sheet, say "July" then you could do Edit / Replace / July [with] July / Replace All which I think would update the formulas Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup Thanks Bill. That is what I was affraid of. Each worksheet is for a month and is linked to other spreadsheets that contain data for the year. It's a monthly report type of workbook. Guess when it is opened I'll just have to be patient while the entire workbook updates. Thanks again for the input. |
#4
|
|||
|
|||
I wrote:
If the links are all in the same sheet, say "July" then you could do Edit / Replace / July [with] July / Replace All which I think would update the formulas I meant: If the links are all *to* the same sheet, say "July" then you could do Edit / Replace / July [with] July / Replace All which I think would update the formulas Sorry! Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Update Individual Links | Excel Discussion (Misc queries) | |||
Can you update links between workbooks without them both open? | Excel Discussion (Misc queries) | |||
copy worksheet ... formulas do not update | Excel Worksheet Functions |