| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup retaining data?
I've taken over work on several spreasheets and am trying to figure out why
the vlookup in one seems to retain data even after the spreadsheet it is calling has been deleted. In my cell I have: VLOOKUP(A4, 'C:\Spreadsheets\[Test2.xls] MainSheet'!$A$1:$B$204, 3, False) So from Test1.xls my vlookup is calling Test2.xls, but I've deleted Test2 and Test1 still gets populated. How could this be possible? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clearing data but retaining formulas | Excel Discussion (Misc queries) | |||
| Retaining Data when a condition changes | Excel Worksheet Functions | |||
| retaining cell data once entered | New Users to Excel | |||
| Retaining data permanently from periodic changing data in workshe. | Excel Worksheet Functions | |||
| Retaining Daily Data Automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
