Pivot table The reference is not valid error

I am having trouble with Resrehsing pivot tables: The pivot table 'PivotTable1' could not be refreshed. The following error was reported: The reference is not valid'.

For example, I took standard NAV018 - Accounts Receivable with Details Jet Express report for NAV2013. I inserted two additional fields, one from Cust. Ledger Entry table (master table) and one from a Customer table (linked table). When Refreshing Jet Report I get the above error. I am trying to pinpoint the reason for that for days now and but still cannot pinpoint, what is going wrong and why (and I have tried all other known suggestions and I am sure that the added field names are correct since the data on the Report tab are exported correctly). I have tried several different things but I cannot find any logic or consistently reproduce an error. Here is sone of the things I have tried so far.

On my laptop I use Excel 2013 ENU with NAV2013R2 with SLV language. For example, on my computer with local NAV2013 installation the report works, however, when I copy the report to another computer where for example they have Excel 2013 with SLV language pack the report does not work. Then I remove the tab with the Pivot Table, create a new Pivot table on their computer and it works. When I copy the file to my PC it fails. I tried to copy both files to other PC-s and some work with my original, the others with the alternative. I cannot find the correct pattern and rule, which version will work where.

I have inserted a few more columns thus creating new date ranges (90-180, 181-270, 271-360, 361+) besides the standard ones. I inserted them before the last standard column (91+) and had to redo the Pivot table. My first attempt had been to just change 91+ column into 361+ column without any new inserted columns, but then Pivot Table failed since apparently it was still referencing the 91+ caption, which no longer existed in the source data. So unlike NAV, Pivot Table does not like renaming fields.

I suspect that there is something related to language and captions, but after hours of trying with several tables I still do not know, when a report will work on all machines and when it will fail. I have tried manually setting captions and recreating Pivot Table in hope that if I set the caption manually, the Pivot Table will work. I have tried using standard report captions (ENU) and changing names in the Pivot table itself. Again, sometimes it works and sometimes it doesn't. I tried also with change Language in Jet Reports Data Source Settings from SLV to ENU or even to 000.

The bottom line is, can someone clarify the implications of Language setting in Data Source Settings, what is the best strategy to translate standard Jet Reports provided by Jet Reports (translate field names, translate captions, translate just pivot table field names?) and most importantly, how Pivot table can be updated in cases of addition of new fields or at least, how to debug pivot table refresh, to figure out, what is going on?

Attached is a sample report and JetReports log file.

• sample_report.zip