For Mac Users: In the top menu bar, navigate to Tools > Add-ins. You should now be able to access the Data Analysis command under the Data tab. If Analysis ToolPak does not appear as one of the Available add-ins, then click Browse to locate it. You should have a pop-up window on your screen make sure Analysis ToolPak is checked. Where it says Manage at the bottom, select Excel Add-ins from the drop-down menu and click Go.
Jump to Excel for the Mac - If the Data Analysis command is unavailable on the Tools menu, then you must install and load it following these steps: On the. I would like to do the same in a spreadsheet that I am creating and using. I have seen spreadsheets where there are macros embedded that 1) check to see if the Analysis Tookpak is loaded and 2) Load the Analysis Tookpak if it is not loaded. Automatically Load Analysis Toolpak Add-in Nov 17, 2006.
0 kommentar(er)
