web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

The data retrieved has been limited to the cell refresh limit of 1000000 cells

(0) ShareShare
ReportReport
Posted on by 22,797 Most Valuable Professional

Dear Experts,

Can I kindly ask for your suggestion on this?

I have one of the customer has loads of Fixed Asset data, hence while they are using Excel Add-in (Fixed Asset V2), system is giving the limitation error 

Do you have any suggestion to increase the capability here? 

010.PNG

Thank you in advance.

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Ramit,

    1 mio records it the current limit to my knowledge.

    Increasing this limit does not seem to make much sense as Excel has a limit of 1,048,576 rows.

    So, even if you could export 1.5 mio records, you might have difficulties opening the file in Excel.

    Can't you apply some filters and 'split' the export?

    Best regards,

    Ludwig

  • Ramit Paul Profile Picture
    22,797 Most Valuable Professional on at

    I agree, in that case, probably I can remove some columns from the template and recreate one template.

    Do you think this can be user friendly approach?/

  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,025 Super User 2025 Season 2 on at

    Hi Ramit,

    You can indeed remove some not required fields. What is the exact purpose of this Excel sheet and how many assets do you have to report here? Could a solution via Power BI be a better approach here?

  • Ramit Paul Profile Picture
    22,797 Most Valuable Professional on at

    one of our Spanish customer needs to see all fixed assets with books, I can feel this is not meeting their purpose, I think we can make a template by removing some values.

    Power Bi is also an option, thank you Andre.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans