web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Ramit Paul Profile Picture
    22,797 Most Valuable Professional on at
    RE: The data retrieved has been limited to the cell refresh limit of 1000000 cells

    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.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    298,941 Super User 2025 Season 2 on at
    RE: The data retrieved has been limited to the cell refresh limit of 1000000 cells

    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
    RE: The data retrieved has been limited to the cell refresh limit of 1000000 cells

    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
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: The data retrieved has been limited to the cell refresh limit of 1000000 cells

    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

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,257

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 611 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans