vlookup help

d0wnt0wn

Well-known Member
Joined
Oct 28, 2002
Messages
771
Hi there, I have a workbook that has many vlookup formulas to another workbook. I use this as an estimating spreadsheet... so the prices are constantly changing. My problem is, lets say I am working on a current estimate with current pricing... if i open an estimate that i did last year then all the pricing on my current estimate changes to those old prices... any way to stop this from happening?
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
not without a VBA solution to change a vlookup from formula to a value.

But a thought - if the estimate from a year ago has vlookups to another sheet, can you open the old one and answer "N" to update links when you open.
 

kjo1080

Active Member
Joined
Aug 2, 2004
Messages
325
If you open a new excel application first, then open your old pricing, it will not automatically update your new file!

-kjo1080
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,541
Members
410,547
Latest member
htran4
Top