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.

Find more posts tagged with

Reports

Accepted answers

All comments

Genevieve P.

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

Thanks for the research @Genevieve P.!

ker9

I've been using Power BI or Access to open those giant user access reports.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.