Linking workbooks

  • Thread starter Thread starter BB
  • Start date Start date
B

BB

When I copy and paste special from one workbook into
another, blank cells show a 0 (zero). How do I avoid this?
 
Hi BB

Yes : your formulas with no value will show 0

You can uncheck Show zero's in Tools>Options ...View
 
BB

If these are formulas linking back to the target sheet, you could trap the
blanks with an IF statement.

=IF(Sheet1!A1="","",Sheet1!A1)

OR Tools>Options>View. Uncheck "Zero Values"

Gord Dibben Excel MVP
 
Thanks Gord, that worked!
-----Original Message-----
BB

If these are formulas linking back to the target sheet, you could trap the
blanks with an IF statement.

=IF(Sheet1!A1="","",Sheet1!A1)

OR Tools>Options>View. Uncheck "Zero Values"

Gord Dibben Excel MVP

this?

.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Copying linked sheet 2
How to create absolue path link to another workbook (Excel 2003) 1
Linking blank cells 1
Mulitple Workbooks and Ignoring Blank Cells 5
Question regarding link cells in different workbooks 1
Copy-Paste Chart into Word from Excel 2007 3
Copy formulas to another workbook 4

Back
Top