Hyperlink issues

Question

Please see here --

The source file is "Guage_Liste_DB" have "table_Guage data"

The data from "Table Guage_DB" is copy pasted in other workbook sheet "dashboard" which is other workbook. See the addrese.

There are NO entries sorce file "Guage_Liste_DB" have "table_Guage data" see D13 onwards

But the final destination sheet "Dashboard" have value "0" from D10 onwrads. This cell onwards must be nothing as the source file is having nothng.

Answer 1

Hi Chaturvedi, Santosh,

For your concern, there is two approaches based on your preferences:

• If you want a quick display fix, you can go to File > Options > Advanced > scroll down to Display options > uncheck the box of "Show a zero in cells that have zero value" > OK

• If you want the cell value is truly blank, you will need to modify the formula. Instead of your current formula as 'SheetName'!Cell, use this formula instead =IF('SheetName'!Cell = "", "", 'SheetName'!Cell)

Hope this information would be helpful. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.    

Thank you for your understanding and cooperation. I'm looking forward to your reply.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.