ExcelBanter - How do I resolve number on screen printing as #REF

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I resolve number on screen printing as #REF (https://www.excelbanter.com/excel-discussion-misc-queries/91415-how-do-i-resolve-number-screen-printing-ref.html)

sallylg

How do I resolve number on screen printing as #REF

I have an excel worksheet which shows the numbers perfectly, however, one
number when it is printed or print previewed appears as #REF

The number is obtained from another worksheet by formula but there is no
problem with the other worksheet.

why is this and how can I resolve it?

sallylg

How do I resolve number on screen printing as #REF

RESOLVED

"sallylg" wrote:

I have an excel worksheet which shows the numbers perfectly, however, one
number when it is printed or print previewed appears as #REF

The number is obtained from another worksheet by formula but there is no
problem with the other worksheet.

why is this and how can I resolve it?

All times are GMT +1. The time now is 12:29 AM.