Excel Sharepoint Linked Workbook - show blank for cells returning "0"s?

[Sunshine8790]

I have 2 sharepoint workbooks. One filled with data based off the other.
Currently the formula looks like this:

='https://name/censored_for_privacy_com/Documents/[Name Censored 8_7_23.xlsx]Main Sheet'!$A$1:H3000

I do this so that there is room for rows of data to update automatically (currently data only goes to row 1699 of the linked workbook - but when new data is entered, it could be less or more rows - never more than 3000 rows, so this allows for that flexibility without having to manually change the formula every time).

However - because of this, all rows below 1699 to 3000 are showing 0s.

And because it's linked data, I can't just delete those rows. Is there a way to edit the formula for it so that if the data in column A is a "0" to show nothing for that row?

 

[Fluff]

How about

=let(a,='https://name/censored_for_privacy_com/Documents/[Name Censored 8_7_23.xlsx]Main Sheet'!$A$1:H3000,if(a="","",a))

 

[Sunshine8790]

How about

=let(a,='https://name/censored_for_privacy_com/Documents/[Name Censored 8_7_23.xlsx]Main Sheet'!$A$1:H3000,if(a="","",a))

It is giving me a red dotted line around the formula instead of the data.

 

[Fluff]

I've never seen a red dotted line around a formula, so have no idea what it means.

 

[Sunshine8790]

I've never seen a red dotted line around a formula, so have no idea what it means.

Ahhh. I removed the = from in front of the url address to the linked sheet and it worked!
Thank you!

 

[Fluff]

Glad you sorted it & thanks for letting us know.