#VALUE

  • Thread starter Thread starter Kieran H
  • Start date Start date
K

Kieran H

Hi

I have a worksheet that has replaced virtually all data with the
#VALUE error on opening. The cells are a mixture of text/dates/
nimbers but no formula or links.

Any thoughts?

Cheers

K

(Office 2007)
 
Hi

I have a worksheet that has replaced virtually all data with the
#VALUE error on opening.  The cells are a mixture of text/dates/
nimbers  but no formula or links.

Any thoughts?

Cheers

K

(Office 2007)
Click to expand...

Does the value in the formula bar also say #VALUE ?
 
Does the value in the formula bar also say #VALUE ?
Click to expand...

Thank you for responding

Yes the value in the formula bar says #VALUE - If I copy the sheet/
value to a new workbook it says
#VALUE

Basically a user has opened the workbook from a document management
system and the data - a testing logs data has completely been replaced
with #VALUE (With the exception of a few cells here and there.

Cheers

Kieran
 
Back
Top