Excel: All text cells converted to #VALUE

Microsoft Excel 2003 (full)
August 31, 2010 at 06:37:19
Specs: Windows XP
Hi, my mother (of all people) has been managing an excel file with 2000+ rows for her real estate business. It contains column headers for ID, Location, Price etc and is just simple data entry - no formulas. She has recently sent to me and now all cells which had text in them are now showing as #VALUE! (even column headers). All cells with numerical entries are showing the original numbers ok. There are two worksheets and both have exact same issue. Very very odd. Can one of you geniuses help me - I'm all googled out ;-)

Thanks in advance!


See More: Excel: All text cells converted to #VALUE

Report •


#1
August 31, 2010 at 07:17:01
The #VALUE error is usually associate with math functions on TEXT values, your sure that none of the cells have any type of formula in them?


Without knowing what version of Excel your using, you can try:

For Excel 2000 or 2003:

Detect & Repair:

On the Task Bar
Help
Detect & Repair


For Excel 2007:

Running Microsoft Office Diagnostics from within Excel

Click the Microsoft Office button

Click on the Excel Options button to bring up the Excel Options dialog box

Click on the Resources button in the left hand pane

Click on the Diagnose button in the right hand pane

Click Continue

Click Run Diagnostics


Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button

Click All Programs

Click Microsoft Office folder

Click Microsoft Office Tools

Click Microsoft Office Diagnostics

Click Continue

Click Run Diagnostics


Try that and see if it helps.

MIKE

http://www.skeptic.com/


Report •

#2
August 31, 2010 at 07:32:44
Mike, thanks for the quick reply. Its 2003 - I just tried Detect & Repair, it went through an install phase and ended with a window saying Microsoft Excel 2003 Standard Edition Setup has completed successfully but nothing has changed. Ran it again for good measure but same again.

There were definitely no formulas present in the cells that have the issue. The only formulas in the sheet were a column that converted a Euro price to Sterling. Thats what baffled me - the VALUE error for me is when a formula is trying to calculate and finds text (my dumbed down explanation). My mother has recently moved from a 2003 version to 2007 on her desktop - wonder if she's done something there inadvertently...


Report •

#3
August 31, 2010 at 08:06:34
Try saving the file as, either SYLK or HTML, some of the formatting may be lost but you may get your data back.
After you save as SYLK reopen with Excel and if it looks OK resave as a regular Excel file.

My mother has recently moved from a 2003 version to 2007 on her desktop
Have here run a Diagnostic on her machine.


MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
August 31, 2010 at 08:51:07
Thanks Mike. SYLK isnt an option for me, but HTML hasnt worked. After a bit more quizzing I was advised that some sort of Sync message came up on her 2007 version when she first opened which may have caused the issue - this comes up each time she opens the file so I have asked her to send me the image. Will advise what I come back with in case we can solve it for future ref. Cheers.

Report •

Ask Question