Mar 18 2023 06:24 AM
Hello,
our company switch for Office 2016 to Office 365. After the update the Excle analysis functions are not useable anymore. The function ist not display on the "Data" menu anymore.
I already checked the following steps:
Step_1
Step_2: Insert the analyses function (includes the Fast Frourier Transformation)
But the analysis function are not displayed within the Data menu.... where ist should displayed normaly ... -:(
Do anybody know .. what is wrong in configuration? Have anybody an idea what steps will solve the problem?
Best regards Thomas
Mar 20 2023 02:49 AM
You can access the analysis tools by clicking on the Data tab and then clicking on Data Analysis in the Analysis group.
If the Data Analysis command is not available, you may need to load the Analysis ToolPak add-in.
There is a thread on the Microsoft community forum where a user had a similar issue with the Fast Fourier Transform in Excel 365.
The user was able to resolve the issue by following the steps mentioned in the thread.
You can try following the steps mentioned in the thread to see if it resolves your issue.
I hope this helps! :) ...if not, please ignore it.
*Information and formulas without guarantee.
Mar 20 2023 04:01 AM
Hello Nikolino
many thanks for your reply.
I did already the described steps for loading and activating as described in the displayed screen shots above.
I did the following steps
Loading the toolpack
Activating the "Analysis Functions"
.... No positive result ... The menu group is still missing...
Any further proposal for solving this problem?
Is there any further lib for 64bit needed?
Information: Excel 2016 at my installation point was 32bit noch Excel 365 is an 64bit application.
Do you have any further ideas?
Best regards Thomas
Mar 20 2023 05:15 AM
Does the problem only occur on one computer or does it also affect other computers?
it may also help to deactivate the protected views... (has helped a few times already)
Click the File tab.
Under Help, click Options.
Click Security Center, and then click Security Crust Center Settings.
In the Security Center, click Protected View
It may also help to remove the add-in and install again.
With my add-in, which I test from time to time -> I check the add-in.
Then move the file (*.xla/*.xlam)
Restart Excel -> then everything in the add-in catalog should be removed and integrate it again.
If none of that works, I'll be at my wits end.
The only thing I can recommend is to go through the basics again.