ExcelBanter - Data always hidden on open (excel 2007)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data always hidden on open (excel 2007) (https://www.excelbanter.com/excel-discussion-misc-queries/192877-data-always-hidden-open-excel-2007-a.html)

Jeff Metcalf

Data always hidden on open (excel 2007)

I have a spreadsheet that returns rows from a SQL view (ODBC and MS Query)

Every time I open the spreadsheet, the data rows are hidden. Or if I filter
the rows, I have to clear the text filter, unhide all rows, and then start
over.

Is this a bug? Or a setting?

Thanks in advance

All times are GMT +1. The time now is 01:02 AM.