Skip to main content
Solved

Excel and Acumatica

  • February 4, 2025
  • 9 replies
  • 107 views

  • Freshman II
  • 10 replies

We are having problems using excel on downloaded Acumatica information.  Right now, the problem is with pivot tables.  It won’t let us change what is in the table. We are having to copy the information and paste special in a new workbook and rebuild the pivot table.

Best answer by Samvel Petrosov

@RSMGV can you attach a screenshot or example of that Excel file? Technically, the Excel files exported/downloaded from Acumatica contain a connection configuration to OData, so it maybe so that your security preferences are blocking that and because of that you can’t edit the file.

View original
Did this topic help you find an answer to your question?

9 replies

Forum|alt.badge.img
  • Jr Varsity I
  • 79 replies
  • February 4, 2025

  • Author
  • Freshman II
  • 10 replies
  • February 4, 2025

Thank you but I’m not embedding anything(at least I don’t think so).  Just trying to edit the download from Acumatica in excel.


Nilkanth Dipak
Semi-Pro II
Forum|alt.badge.img+10

Hi ​@RSMGV,

Is it possible that you are in "Viewing" mode for the Excel document? You can check this in the upper-right corner of the page, where there is a dropdown selector. Please ensure that you are in "Editing" mode to make changes.


  • Author
  • Freshman II
  • 10 replies
  • February 5, 2025

Thank you, but yes, we are in editing mode.


Samvel Petrosov
Jr Varsity II
Forum|alt.badge.img+5
  • Jr Varsity II
  • 143 replies
  • Answer
  • February 5, 2025

@RSMGV can you attach a screenshot or example of that Excel file? Technically, the Excel files exported/downloaded from Acumatica contain a connection configuration to OData, so it maybe so that your security preferences are blocking that and because of that you can’t edit the file.


  • Author
  • Freshman II
  • 10 replies
  • February 5, 2025

Thanks so much.  I’ll have someone here in security look at that.


  • Author
  • Freshman II
  • 10 replies
  • February 12, 2025

@Samvel Petrosov, how do I refresh the excel worksheet? 


  • Author
  • Freshman II
  • 10 replies
  • February 17, 2025

@Samvel Petrosov, how do I refresh the excel worksheet?


Samvel Petrosov
Jr Varsity II
Forum|alt.badge.img+5
RSMGV wrote:

@Samvel Petrosov, how do I refresh the excel worksheet?

You should be able to simply right-click any cell of the exported grid and hit Refresh action

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings