Update links on one sheet only?

[Tubig]

Hello all,

Is there a way that I can create a macro to only update the links on one sheet and not the others? Sounds simple but I think not.

Thanks

 

[Richard Schollar]

Hi Tubig

The absolute easiest way I can think of would be to record a macro of you selecting all worksheet cells (the button above the row numbering/to left of column lettering) and doing a Find/Replace on "=" with "=", which should force all externally referenced formulas in that sheet to update their values.

Hope this helps!

 

[Tubig]

Hi Tubig

The absolute easiest way I can think of would be to record a macro of you selecting all worksheet cells (the button above the row numbering/to left of column lettering) and doing a Find/Replace on "=" with "=", which should force all externally referenced formulas in that sheet to update their values.

Hope this helps!

Interesting, I'll give it a try.

Thanks!

 

[Tubig]

Hi Tubig

The absolute easiest way I can think of would be to record a macro of you selecting all worksheet cells (the button above the row numbering/to left of column lettering) and doing a Find/Replace on "=" with "=", which should force all externally referenced formulas in that sheet to update their values.

Hope this helps!

No I couldn't get that to work.

This is one of the formulas that I want to update with a macro:

=IF(M14>0,VLOOKUP(M14,'P:\Macro\PERSONAL.XLS'!LUMBER_PRICING,MATCH($K53,'P:\Macro\[PERSONAL.XLS]LUMBER'!$D$5:$O$5,0),FALSE),0)

Any ideas?

 

[Richard Schollar]

What happens when you replace the "=" with "="?

 

[Tubig]

What happens when you replace the "=" with "="?

It just changes the formula to this:

"="IF(M14>0,VLOOKUP(M14,'P:\Macro\PERSONAL.XLS'!LUMBER_PRICING,MATCH($K53,'P:\Macro\[PERSONAL.XLS]LUMBER'!$D$5:$O$5,0),FALSE),0)

and the formula becomes visible. I am doing something wrong?

 

[Richard Schollar]

When you hit Ctrl+H (which is the shortcut for Find/Replace) you should just be typing = into the Find What box and Reaplce With = too (so no quotes), and then click OK. Basically, you are not changing the formula in any way - what it should do (and does on my computer) is force Excel to recalc the formulas in the sheet (and update external references).

If this isn't happening for you, please do post back

 

[Tubig]

I figured it out with what you were saying.

Sorry about that (i can be a bone head sometimes).

When I update that cell, the others on the sheets update as well.

I give up. Thanks anyways.