Linked worksheets

  • Thread starter Thread starter Rosemary
  • Start date Start date
R

Rosemary

Hi! I'm learning how to link worksheets for a master
report. When the master worksheet gathers the figures
from the subworksheets, all blank cells show as zeros. How
can I stop these zeros?; the cells should be blank. I
cannot deselect the "show zeros" option because zeros are
put into some of the cells. I simply don't want a cell
that should be blank to show a zero. Thank you.
 
From the menu > Tools > Options > select the view tab,
near the bottom uncheck the box "display zeros"

hth
 
As answered at your previous post:

Instead of a simple link, e.g.:

=[LinkedWB1.xls]Sheet1!A1

you can use an IF formula:

=IF([LinkedWB1.xls]Sheet1!A1="","",[LinkedWB1.xls]Sheet1!A1)
 
Back
Top