Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to change 'Read On...
Small and medium business | Business Central, N...
Unanswered

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

(1) ShareShare
ReportReport
Posted on by MF-24070306-0 2
 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:
Business Central
  • Valentin Castravet Profile Picture
    Valentin Castravet 24,785 Super User 2024 Season 2 on at
    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. 
     
  • Adis Profile Picture
    Adis 2,423 on at
    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
  • Andy Wingate Profile Picture
    Andy Wingate 320 on at
    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
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    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

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans