Why Send to Excel is not enabled in few pages of Dynamics NAV?

jithinmathew01

Hi All,

We have been facing an issue on Send to Excel functionality of Dynamics NAV. For few few pages, Microsoft Excel option is grayed out where as word, print and attachment options are fine. Mostly, worksheet type pages are missing the Send to Excel option. But the same worksheet page in Cronus database is absolutely fine and we are able to export the data without any problem.

Please help me with this issue if anyone had come across the similar issues and resolved the same.

Thanks,
Jithin.

Wisa123

Hi,

Just a wild guess, since i've had similar issues before.
Is the page a standard object or are there customizations?
Some properties such as "ShowAsTree" disable the Excel functionality in some Versions of NAV.

Try to import the standard page and try again.
If there are no modifications to the page ... well then I don't know either .

Wisa

jithinmathew01

Hi Wisa,

I had done the same. Send to Excel option is greyed out even after imported the standard object. It seems something need to be done in general setup, not in page level.

Thanks,
Jithin.

Wisa123

Hi Jithin,

Which pages are we talking about? Which NAV-Version exactly?
Whats the value of "MaxRowsToExportToExcel" in your CustomSettings.config (server side)?

Wisa

Miklos_Hollender

In my experience you can just use from the left top menu, the blue "V" the print and send to Excel.

jithinmathew01

Hi Wisa,

Sorry for the late reply.

I am facing this issue on Bin Contents page (7374), version NAV 2017.

"Max Data Rows Allowed to Send to Excel" is set to MaxValue in Server Instance. Do you mean the same?

Thanks,
Jithin.

jithinmathew01

Hi Miklos,

My problem is exactly where the place what you mentioned here.
Thanks for the reply.

Regards,
Jithin.

EuropaCuisson

Hi,

I have the same problem with Items by locations (Page 9231)
On windows client, no problem.
But on Web client, Export to Excel is greyed ...