Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUPS ARE MISSING
I created a report with different tabs with various data. I downloaded one
report and moved the information around and used that as my base. I finished putting in all my formulas and saved as a 97-03 since I am working in 2007. Then I saved a copy so I could send it to someone else, but just gave them the data, not the formulas. Now when I open the file it says File Error €“ data may have been lost. All the Vlookup Formulas I entered are gone. The other formulas are there, just not any of the Vlookups. I am not sure what happened or what to do. The funny thing is, the correct data is in the cell, but when you click on the cell is shows =#n/a. Has anyone experienced this problem before? If I can't figured it out, I have to redo all my vlookups. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUPS ARE MISSING
Try to type in a new VLOOKUP formula in a cell?
If it works then most likely there is some corruption in the cells having the VLOOKUPs... Try to Edit one of the cells and just press enter without changing anything. Does it solve the problem? "BeckyB" wrote: I created a report with different tabs with various data. I downloaded one report and moved the information around and used that as my base. I finished putting in all my formulas and saved as a 97-03 since I am working in 2007. Then I saved a copy so I could send it to someone else, but just gave them the data, not the formulas. Now when I open the file it says File Error €“ data may have been lost. All the Vlookup Formulas I entered are gone. The other formulas are there, just not any of the Vlookups. I am not sure what happened or what to do. The funny thing is, the correct data is in the cell, but when you click on the cell is shows =#n/a. Has anyone experienced this problem before? If I can't figured it out, I have to redo all my vlookups. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 VLookups | Excel Worksheet Functions | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
VLOOKUPS | Excel Worksheet Functions | |||
Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
vlookups | Excel Worksheet Functions |