| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formulas across worksheets do not update
I am using VLOOKUP to pull data from one sheet to another. For some reason, whenever I insert a column in the sheet referenced in the VLOOKUP formula the formula is not auto updating the column it should pull data from. Is there a preference setting that I have erroneously changed? -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=484103 |
|
#2
|
|||
|
|||
|
Formulas across worksheets do not update
You got replies to your post in .misc
surg4u1975 wrote: I am using VLOOKUP to pull data from one sheet to another. For some reason, whenever I insert a column in the sheet referenced in the VLOOKUP formula the formula is not auto updating the column it should pull data from. Is there a preference setting that I have erroneously changed? -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=484103 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas across worksheets do not update
I have had a similar problem. What is .misc?
"Dave Peterson" wrote: You got replies to your post in .misc surg4u1975 wrote: I am using VLOOKUP to pull data from one sheet to another. For some reason, whenever I insert a column in the sheet referenced in the VLOOKUP formula the formula is not auto updating the column it should pull data from. Is there a preference setting that I have erroneously changed? -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=484103 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using formulas betweek worksheets | Excel Discussion (Misc queries) | |||
| apply cell names to formulas in multiple worksheets | Excel Worksheet Functions | |||
| Enabling Formulas Between Two Worksheets | Links and Linking in Excel | |||
| Copy worksheets with formulas between different workbooks | Excel Discussion (Misc queries) | |||
| Replicating Formulas with Various Worksheet References | Excel Worksheet Functions | |||
Linear Mode
