Sometimes, when you download an excel report from NAV, it won't allow you to make changes to it. This can be an issue when you want to work with the data. Here are the steps convert the data on the sheet to something you can work with.
- Download the Excel report/file in question
- Right click a single field in Excel that’s in the table (doesn't matter which one)
- Choose Table, then Convert to Range
- It will pop up this message. Click Yes.
- The file will then be completely editable for you.
0 Comments