Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cell to different workbook
Just had a quick question... I have several different worksheets and books
linked to one master workbook. However, if the contents of the cell in the original workbook is blank, it displays a '0' on the master workbook until a value is entered. Is it possible to get the master workbook to appear blank as well until a value is entered and it is updated? Thank you for any help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cell to different workbook
2 work arounds...
1 - Change the formula that you have pointing to the target workbook to an if formula. If the value in the target book is blank ("") then make the value in the master blank, else return the value from the target book. 2 - Tools - Options - View tab - uncheck Zero Values -- HTH... Jim Thomlinson "Matthew" wrote: Just had a quick question... I have several different worksheets and books linked to one master workbook. However, if the contents of the cell in the original workbook is blank, it displays a '0' on the master workbook until a value is entered. Is it possible to get the master workbook to appear blank as well until a value is entered and it is updated? Thank you for any help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cell to different workbook
Worked perfectly, Thanks Jim
"Jim Thomlinson" wrote: 2 work arounds... 1 - Change the formula that you have pointing to the target workbook to an if formula. If the value in the target book is blank ("") then make the value in the master blank, else return the value from the target book. 2 - Tools - Options - View tab - uncheck Zero Values -- HTH... Jim Thomlinson "Matthew" wrote: Just had a quick question... I have several different worksheets and books linked to one master workbook. However, if the contents of the cell in the original workbook is blank, it displays a '0' on the master workbook until a value is entered. Is it possible to get the master workbook to appear blank as well until a value is entered and it is updated? Thank you for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking the last cell in another workbook | Excel Discussion (Misc queries) | |||
linking cell value to specific worksheet in the same workbook | Excel Discussion (Misc queries) | |||
Need help with linking a cell to another workbook? | Excel Worksheet Functions | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
linking cell value in one workbook to a cell in another workbook | Links and Linking in Excel |