LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
Posts: 1
Default All my entries turned to #VALUE!s


I have several MS Excel *.xls files that are lists of things (e.g., list of books, that contains author, title, publishing date, genre info in separate columns. Similar lists for DVDs, basketball games, etc).

When I open one of my lists, for some reason, all the entries in the cells are now "#VALUE!"s. I know that you usually get this if you are using Excel to calculate data, and if the formula you wrote in is incorrect.

But why would all of my entries turn into "#VALUE!"s? It looks like I clicked something that affected the whole file?

To reiterate, the file has no formulas. Just letters and numbers. Sheets are not linked in any way. This is a generic list. It has two sheets, one is "Haves," (as in books I own) second sheet is "Have nots," (books I don't own but want to get).

And it is only this list. Other lists I have are fine.

Any thoughts on how to revert this back to my original data?

I am running Windows 10. MS Excel 2007.

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
Can a cell be turned on or off? painter50 Excel Worksheet Functions 1 March 9th 10 12:42 AM
MACROs Are Turned Off DOUG ECKERT[_2_] Excel Discussion (Misc queries) 1 December 2nd 08 10:44 PM
AutoSum turned off? Leslee Excel Discussion (Misc queries) 2 June 2nd 08 01:27 PM
Worksheet has turned TeeJay Excel Worksheet Functions 0 January 12th 06 08:44 AM
Autocomplete in VBA turned off Spammastergrand Excel Programming 4 July 15th 04 10:36 PM

All times are GMT +1. The time now is 12:06 AM.

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

About Us

"It's about Microsoft Excel"