Excel Row Limitation with Sheet Access Reports
When running an all user sheet access report, does anyone run into an Excel row limitation error?
If so, how have you worked around this?
We have 1M+ rows on our report and it fails. We have too many users to run individual reports and combine. Opening with Microsoft Access has given us trouble.
Justin Peters
Operations Associate
Marsh & McLennan Agency
Answers
-
If the all-user access report is too large, the only way you could split up the file directly from Smartsheet would be to download individual user sheet access reports, as you noted.
I did find a blog online that has some instructions on how to load a large file into Excel. I haven't personally tested this but it may have some helpful information: Loading CSV/text files with more than a million rows into Excel
An alternative would be to use a third party to either open the file or break up the all-user access report to smaller chunks.
Cheers,
Genevieve
-
Thanks for the research @Genevieve P.!
Justin Peters
Operations Associate
Marsh & McLennan Agency
-
I've been using Power BI or Access to open those giant user access reports.