LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2 VLookups Guitarbuyer Excel Worksheet Functions 1 August 4th 08 09:45 PM
Dependent vlookups - nested vlookups (maybe) Maniv Excel Worksheet Functions 1 April 22nd 08 07:40 PM
VLOOKUPS Brett Excel Worksheet Functions 5 June 22nd 06 02:50 PM
Toolbars Missing, And option to Add Missing SmeetaG Excel Discussion (Misc queries) 3 October 19th 05 11:43 AM
vlookups Valerie S. Excel Worksheet Functions 0 January 28th 05 12:55 AM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"