Microsoft Dynamics NAV - Excel Buffer already exsists error

RebeccaRussell

Hello,

One of the users is getting the attached error upon running a report and exporting it into excel,

I have checked and there are no duplicated rows once it has ran.

I have a highly skilled 12 year background within IT/Networking/infrastructure/IT Support including CCNA, however, little within development and SQL and only been working with NAV for the last 18 months since leaving the Royal Navy after serving 10 years.

So I don't know where to start with this error.

Can someone Please help/assist.

Many Thanks

Rebecca

Slawek_Guzek

1) try opening Excel Buffer table in Object Designer and delete everything from it.

It is meant as a buffer only and not supposed to have anything in it.

2) Get back to the developer who did for you customisations sending data to Excel and have him/her fixing the bug

Slawek

RebeccaRussell

Slawek_Guzek

Thanks

see attached this is how the excel buffer table currently looks, I will be safe to delete all entries in this?

Rebecca

pradi

@RebeccaRussell A record variable of excel buffer table must exist in the report.
On prereport write the following code. variableexcelbuffer.deleteall. and make the excel buffer variable as Temporary.

Karenh

It is safe to delete all entries from the Excel Buffer table. It is meant to be used as a temporary table, so records should not be permanently saved.