Query Formulas Command

Problem

Query Formulas command is missing from MacNail accounting software

Diagnosis

Newer versions of Excel for some reason seem to move this around or make it disappear.
Sometimes it can be found in other menus- including the Help menu.

NOTE-- Goldenseal construction accounting software includes a Find command, which is a much simpler way to find specific business transactions.

Solution

If the menu command can't be found, do this to add query formulas:
1. Choose Macro from the Tools menu, and choose Macros from submenu
2. They'll see a list of macros. Scroll down to change.data
3. Click the Run button.
HINT- if you GoTo "file.menu", "edit.menu" etc in the manager, you can see all menu commands and the macro command equivalents.

HINT-- tell users to just leave the formulas in there. They really only need to remove them if they have tons of lines and it starts getting slow. WIth modern computers that is much less likely to be a problem while using MacNail construction accounting software.

Comments

Entered 9/20/01 by Casey. Updated 11/9/2010.