#VALUE

[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)

 

[James Ravenswood]

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)

Does the value in the formula bar also say #VALUE ?

 

[Kieran H]

Does the value in the formula bar also say #VALUE ?

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