Formulas Won't Refresh

By default miExcel will only refresh when a linked cell is changed or you manually refresh it.  This allows miExcel to run efficiently for large spreadsheets.  Excel has a built in shortcut to refresh an entire workbook.  Enter the keyboard combination below to refresh your workbook

CTRL + ALT + SHIFT + F9

If you work with small workbooks and are not concerned with a performance decrease you can enable a setting to cause miExcel to refresh more often.  Specifically it will refresh when a cell is updated and when you first open a workbook.  This will decrease the speed in which your miExcel spreadsheet operates.

1.  Go to the miExcel Tab

2. Click Settings -> Settings

3. Check the box Make Functions Volatile

4. Click Save

• Related Articles

• miExcel Disappeared

  If miExcel has disappeared from Excel the first thing to do is to check and see if the add is just disabled.  To do this follow the steps below: 1. Launch Excel 2. Click File -> Options 3. Click Add-ins 4. Check to see if miExcel is showing in the ...

• miExcel General Ledger User Guide

  See attached.

• miExcel Accounts Payable User Manual

  See attachment tab

• Install miExcel

  In your miExcel folder on your server there is a txt file titled Install.  Open it and copy the address.  Paste the address into your internet browser and run the program when it finishes downloading.   Open Excel.  You will get an error message ...

• Update a Workstation Manually - Connect

  Open the attached document to view the instructions on how to manually update a machine installed with Caselle Connect.