•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Table missing rows, they reappear when Convert to Range
Our take
It sounds like you're encountering a frustrating issue with your shared spreadsheet where a table with 76 rows consistently displays only 10 to 15 rows. This behavior can be perplexing, especially when you're confident that your team isn't intentionally hiding any rows. Converting the table to a range temporarily resolves the problem, but understanding the underlying cause is essential for a long-term solution. Let’s explore potential reasons for this anomaly and how to ensure your data is consistently visible and accessible to everyone involved.
I have a reoccuring issue where a table with 76 rows keeps displaying with only 10-15~ rows. When I Convert to Range the rows reappear. I'm not sure what is causing this issue. It is a shared document but I know my team isn't hiding a bunch of rows.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience