| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Updating formula with link to another worksheet using vlookup
I have a very complex workbook that won't automatically update formula
results which contain the vlookup function to another worksheet. "F9" doesn't update the formulas but clicking in the formula (making it active) does. There are thousands of these formulas which need to be updated and I can't determine the automatic method. This seems to be a problem occasionally when I have the very large and complex workbooks. Example formula: =VLOOKUP($C47,'Merch Spd'!$A$17:$AN$74,35,FALSE)*1000 -- Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) | |||
| Can I link a cell to reflect a worksheet name? | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| Display excel formula on worksheet | Excel Worksheet Functions | |||
Threaded Mode
