MS query - coloured shape to indicate end of query range

[Deirdre784]

Hi, anyone know how to remove (or not have in the first place) the little shape that appears in the bottom right cell of a query range result? Looks like 3 building blocks making a triangle. I'm quite used to it, and use MS queries a lot, but my bosses aren't keen on the shape Had hoped to add an image but don't seem to be able to.

Any help much appreciated.

Deirdre

 

[sheetspread]

In the Excel tab or query window?

 

[Deirdre784]

In the query result window, bottom right corner of the bottom right cell (final col and row). Not the green triangle on top left of cells showing number format error.

 

[sheetspread]

I don't see one in mine (nor the Excel output). If you want to send me a sample file I can test some ideas.

 

[Deirdre784]

Thanks for your reply. What happens when you return the data to excel though? That’s where i get the blocks. Will try and send a picture shortly (I couldn’t work out how to fo it yesterday).

 

[Deirdre784]

Seems I can't attach images. As I'm on a work computer I won't be allowed to download any of the add-ins to enable me to attach a file, and we don't use dropbox or google docs...... I'll try and replicate something at home and try again.

 

[Deirdre784]

I use onedrive at home. Can I upload an image from there?

 

[Deirdre784]

https://1drv.ms/f/s!AkR-1MiS5tKMgdNQjcDA4RYIZLmldg

Finally managed to save 2 small clips via onedrive (link above). Not the same table, but I've zoomed in on the shape in case that helps.

I would also like to force the table to return a '.' (an entry we use for 'not applicable') where no data is found. Is that possible?

Many thanks.

 

[sheetspread]

Does this help?

https://social.msdn.microsoft.com/F...ll-on-table-from-external-data?forum=exceldev

If you're referring to the blue bar chart symbol, it's to mark a table. It will go away if you convert the table to a range or, according to the link above, protect the worksheet.

The symbol actually is in the Excel page of my file, just so small that I thought it was the green triangle until I magnified.

 

[Deirdre784]

Brill, thanks so much, I’ll give that a try (hopefully it won’t stop me refreshing the table though).