A person in our office created a workbook in 2002. That workbook was then
sent to several people who have 2003 and others who have 2002. Those that
have 2003 received several #Ref errors. However, those with 2002 could see
everything. The cells that give the errors are only formulas or linked cells
within the workbook. Is there a way to avoid this because we have people in
our office using 2002 and 2003 until we can get everyone switched over.

Any suggestions would be helpful as we have never seen this before.

Thanks!
Trish

Are you positive that the original formulas point to a cell in the same
workbook?

There is a registry setting that is local to each pc that avoids a #value error
if the formulas are links to other workbooks and the user chose not to update
links.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

But this won't apply if your formulas do point to cells within the same
workbook.

TJAC wrote:

A person in our office created a workbook in 2002. That workbook was then
sent to several people who have 2003 and others who have 2002. Those that
have 2003 received several #Ref errors. However, those with 2002 could see
everything. The cells that give the errors are only formulas or linked cells
within the workbook. Is there a way to avoid this because we have people in
our office using 2002 and 2003 until we can get everyone switched over.

Any suggestions would be helpful as we have never seen this before.

Thanks!
Trish

--

Dave Peterson

Actually you are right, some of them are pointing to another workbook on her
hard drive that we cannot access. With 2002, that doesn't matter, it still
displays the information when you say no to updating.

What will that do if we change the registry and there are formulas that link
inside AND outside that workbook? This one does contain both I have found.

Thanks!

"Dave Peterson" wrote:

Are you positive that the original formulas point to a cell in the same
workbook?

There is a registry setting that is local to each pc that avoids a #value error
if the formulas are links to other workbooks and the user chose not to update
links.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

But this won't apply if your formulas do point to cells within the same
workbook.

TJAC wrote:

A person in our office created a workbook in 2002. That workbook was then
sent to several people who have 2003 and others who have 2002. Those that
have 2003 received several #Ref errors. However, those with 2002 could see
everything. The cells that give the errors are only formulas or linked cells
within the workbook. Is there a way to avoid this because we have people in
our office using 2002 and 2003 until we can get everyone switched over.

Any suggestions would be helpful as we have never seen this before.

Thanks!
Trish

--

Dave Peterson

The registry tweak will make excel behave like earlier versions. If you answer
"no" to the update links prompt, you won't see an error.

Remember that this is a setting for each pc. If multiple people are having the
trouble, you'll have to make the change on each of their pcs.

TJAC wrote:

Actually you are right, some of them are pointing to another workbook on her
hard drive that we cannot access. With 2002, that doesn't matter, it still
displays the information when you say no to updating.

What will that do if we change the registry and there are formulas that link
inside AND outside that workbook? This one does contain both I have found.

Thanks!

"Dave Peterson" wrote:

Are you positive that the original formulas point to a cell in the same
workbook?

There is a registry setting that is local to each pc that avoids a #value error
if the formulas are links to other workbooks and the user chose not to update
links.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

But this won't apply if your formulas do point to cells within the same
workbook.

TJAC wrote:

A person in our office created a workbook in 2002. That workbook was then
sent to several people who have 2003 and others who have 2002. Those that
have 2003 received several #Ref errors. However, those with 2002 could see
everything. The cells that give the errors are only formulas or linked cells
within the workbook. Is there a way to avoid this because we have people in
our office using 2002 and 2003 until we can get everyone switched over.

Any suggestions would be helpful as we have never seen this before.

Thanks!
Trish

--

Dave Peterson


--

Dave Peterson