How to change 'Read Only' to 'Edit' in my excel export so i can publish mass changed data

(1) Share

Report

Posted on by MF-24070306-0

I would like to edit information on an excel export of data from Business Central that is set as read only, so i can publish my changes in BC. How do can I do this?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Valentin Castravet 28,498 Super User 2025 Season 2 on at

Like (0)

Report

How to change 'Read Only' to 'Edit' in my excel export so i can publish mass changed data

andywingate is correct, the Edit in Excel function cannot be used in all pages. The sales lines is one such page where Edit in Excel is not possible.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Adis 5,555 Super User 2025 Season 2 on at

Like (0)

Report

How to change 'Read Only' to 'Edit' in my excel export so i can publish mass changed data

Hey,

There is no setup for it. The definition what you can change is defined by the data entity, i.e. a developer needs to either change the fields in the entity to delete, update, insert or a new entity needs to be created to do so.

Kind regards, Adis

Was this reply helpful? Yes No
Andy Wingate 324 on at

Like (1)

Report

How to change 'Read Only' to 'Edit' in my excel export so i can publish mass changed data

Hiya,

Edit in Excel - which you are clearly using - lets you edit any field you could edit from the related page.

You have loaded the Sales Lines page - there is no edit mode on that page, so an Edit in Excel of that page wont let you edit anything!

However, there is another page you can use in Edit in Excel - the salesDocumentLines; to get that just create a new sheet in the same workbook and use design to pic the table

add all field (or the ones you want) and away you go!

Edit-in-Excel will still only ever allow changes to field you could have changed (e.g. don't try to change a flow field, the publish for that row will fail)

Here is a short video of the steps. https://www.screenpresso.com/=Au6if

Good luck,

Best

Andy

Was this reply helpful? Yes No
KasparsSemjonovs 4,575 Super User 2025 Season 2 on at

Like (1)

Report

How to change 'Read Only' to 'Edit' in my excel export so i can publish mass changed data

From Business Central You have to select the option "Edit in Excel", not "Open in Excel".
If You use Edit in Excel, then the Publish button will be active (if You have all the setups done that this feature is enabled).
Viewing and Editing in Excel From Business Central - Business Central | Microsoft Learn

Was this reply helpful? Yes No