Excel Open lines: Error Formatting Binding Columns

(0) Share

Report

Posted on by BillDoors

457

Hi experts,

Description of problem:

Ultimately, would like to edit and update from excel to d365. The issue first surfaces when opening the Vendor invoice journal line data source. Attempting to add fields and open in excel get the error. " Error Formatting Binding Columns. Details: The column index value is out of the allowed range. Use a value (0 or higher) that's less than the number of columns.

Users windows version is 10.0.18362 Build 18362
Excel version: version 1903 (Build 11425.20096 Click-to-Run)

Error message: Error Formatting Binding Columns.

Details:

The column index value is out of the allowed range. Use a value (0 or higher) that's less than the number of columns.

Thanks in advance.

All responses (4)

Answers (0)

Sort by

André Arnaud de Cal... 307,829 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi BillDoors,

Can you show what fields you have used? In the options section of the Excel Data integrator, there is an option to clear binding cache. Have you tried this as well?
BillDoors 457 on at

Like (0)

Report
Copy link

Link copied!

Hi André, thanks a lot for your input. I will check that information with my customer soon and get back to you.
BillDoors 457 on at

Like (0)

Report
Copy link

Link copied!

Hi André,

We followed your suggestion and cleared the binding cache but we stiil get the same error message

The fields we are trying to add are:

- Account.BusinessUnit

- Account.Department

- Account.Events

*We also tried from D365 Reseting the Usage, had the customer log back in and attempted to add the fields again with no luck.

Customer Excel version is 1903

We tried from a different machine using version 1902 and it worked fine so we thought that the issue was the version. However, just to make sure we tried from a third machine also using 1903 and it also worked which means the Excel version is not the problem.
André Arnaud de Cal... 307,829 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi BillDoors,

Have you tried to get the dimensions from the default dimension field? As this is a vendor invoice journal, the account contains only the vendor account. The dimension field has the individual dimensions for all account types other then main account.