#VALUE
 

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)

#VALUE
 

On Sep 29, 12:05*pm, Kieran H wrote:
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 ?

#VALUE
 

On 30 Sep, 14:24, James Ravenswood wrote:
On Sep 29, 12:05*pm, Kieran H wrote:

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 ?

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