...that we blogged about here. What's new, you ask? Quite a bit... we've been busy. We have changed the way you input transaction log growth. In the previous versions you had to enter how ...
Updated Jul 01, 2019
Version 2.0
Blog Post
2 MIN READ
We updated the Exchange 2007 Mailbox Storage Requirements Calculator (again)...
Hey Jeff/Del,
I figured out the issue. You are using Excel 2003 aren't you? By default certain formulas are not enabled unless you load the Analysis Toolpack. For instance, I make use of MROUND function in this version of the calculator and that is only loaded in 2003 with the Analysis Toolpack.
To load the Analysis Toolpack:
1. On the Tools menu, click Add-Ins.
2. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.
3. If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it.
4. Click Tools on the menu bar. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu.
Ross
I figured out the issue. You are using Excel 2003 aren't you? By default certain formulas are not enabled unless you load the Analysis Toolpack. For instance, I make use of MROUND function in this version of the calculator and that is only loaded in 2003 with the Analysis Toolpack.
To load the Analysis Toolpack:
1. On the Tools menu, click Add-Ins.
2. In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.
3. If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it.
4. Click Tools on the menu bar. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu.
Ross