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

Tags:

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Justin Peters

    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

  • Justin Peters
    Justin Peters ✭✭✭✭✭

    Thanks for the research @Genevieve P.!

    Justin Peters

    Operations Associate

    Marsh & McLennan Agency