Frequently Asked Questions

 

1          HOW IS SOFTWARE DELIVERED?

Standard software delivery is in digital format by program download. After making a purchase download the program from the link provided.

 

2          WHAT ARE THE REQUIREMENTS TO USE THE SOFTWARE?

To use our Excel based software you require Microsoft Excel installed on your computer. Software is written with Excel 2000/2003/2007 but most software features should run on Excel versions from 97 on. If you access the software as a compressed (zip) file it will require unzipping for use. Trial Zip software is available free from Winzip ( www.winzip.com ).

Generally Excel on Macs does not support all macro functions so some functionality may be missing. Depending on the software title this may or may not be an issue. All software is available free for evaluation so the best option if in doubt is to is download it and give it a test.

 

3         CELLS AND WORKSHEETS ARE PROTECTED, HOW DO I UNPROTECTED THEM?

Input cells (yellow) are not protected and these are the only cells you need access to. In all our software all other cells and Visual Basic code are protected to ensure integrity and protect source code. You do not need to unprotect any cells. The software is fully functional and the protection is in place to ensure the software code is not corrupted. Please note that trying to unprotect cells and, worksheets and macros is a in violation of your agreement.

 

4          CAN I TRY BEFORE I BUY?

Software is provided with a free demo version. This provided limited functionality but it allows you to test prior to purchase. If the software meets your requirements payment is required for the full version!

 

5          MACROS, WHAT ARE THEY AND WHY DO I NEED TO ENABLE THEM?

Macros are programs embedded in the Excel spreadsheet to provide software functionality. They must be enabled or the software will not function.

 

6          WHY DO I GET A SECURITY MACRO WARNING? SHOULD I BE CONCERNED?

Depending on the security settings on your computer you may be presented with a message advising that the software contains macros with a prompt to Disable or Enable Macros. Macros must be Enabled for software to function.

 

7          HOW DO I ENABLE MACROS?

If you are presented with a prompt to Disable or Enable Macros when you open the software click Enable Macros. If you receive no prompt and macros are disabled you will need to adjust your Macro Security Level.

 

8          HOW DO I ADJUST THE MACRO SECURITY LEVEL?

To adjust macro security levels from Excel go Tools, Macro, Security, Security Level. It is recommended that you select Security Level as Medium. When you open software with macros and Security Level is set as Medium you are presented with a message advising that the software contains macros with a prompt to Disable or Enable Macros. Once you have made your adjustment close Excel and reopen, then when prompted click Enable Macros.

 

9         WHY DO I GET A PROTECTED WITH ENCRYPTION METHOD NOT AVAILBALE IN FRANCE MESSAGE?

This problem is due to a bug in the Microsoft Regional Settings software. It may also appear in the Dutch version. To by pass it you need to change your regional setting to English United States or anything other than France. To do this:

* On the Windows Start menu, point to Settings, and then click Control Panel.
* Double-click the Regional Settings icon.
* On the Regional Settings tab, select English United States.
* Click OK.

This should fix the problem. Further information on this is available at the Microsoft internet site. You can also download a patch from Microsoft to fix the problem (but it is quite large.)