Listed below are the solutions to problems occasionally encountered by users when receiving, opening and using spreadsheets from Business Spreadsheets Dot Com.

Problem - The file you requested has failed to arrive by email.

Solution - Should the file you request fail to arrive the first time it is sent please make a second request. The second time we email a file we CC it to ourselves at info@businessspreadsheets.com. This way we can be certain that the file is leaving our server "intact" and complete (we have never actually had a problem in this area, but CCing the file to ourselves is a very good way for us to ensure that despatch has indeed taken place). When we email out the password for the second time we will then report in our email to you whether the file was depatched OK.

Should the file fail to arrive on the second occasion you may find it helpful to look into the following possible causes:

• The file may be too large for your company account, personal account or ISP (internet service provider). Our files range from approximately 100KB in size upwards.
• Your company or personal firewall may be preventing the attached spreadsheet's passage to your mail box.
• Your virus checker may be removing or deleting the file.
• Your Outlook/email program settings may be preventing you from viewing or receiving the email attachment.

Should the cause remain unresolved contact us and we can despatch the file on CDR (additional charges apply).

Problem - The macros do not operate.

Solution - Your Excel spreadsheet is set in a security mode to prevent macro operation.

To solve this problem enter the,

<TOOLS><MACRO><SECURITY...>

dialogue from the Excel main menu. Please note that sometimes the <SECURITY...> option may not be visible until the down arrows at the bottom of the <MACRO> menu have been selected.

You will be presented with three possible security settings. Your system is probably using the highest, or medium level of security.

If Excel is set to the highest security setting macros simply will not operate. Modify the selection to one of the "lower" security settings, we strongly recommend use of the medium setting. If Excel is set to medium level security you may have been selecting "Disable Macros" when opening the file.

Using the medium setting you will be asked if you wish to enable the spreadsheet macros each time the spreadsheet is opened. You must select "Enable Macros" on each occasion you wish to use the spreadsheet macros.

Using the lowest security setting you will not be prompted by Excel regarding the use of macros, if they are in the spreadsheet then they will be enabled.

NOTE: When the spreadsheet security settings have been modified you may need close and reopen Excel for them to take effect.

Problem - After significant spreadsheet modification the spreadsheet macros no longer work.

Solution - This could have any number of causes, primary possibilities are listed below. REMEMBER - Always back up a spreadsheet before making modifications.

• A range name may have been deleted.
• A range may have been renamed.
• A range may have had a column inserted in an operationally "critical" area.
• A sheet may have been deleted.
• A sheet may have become hidden.
• A sheet may have been renamed.
• A sheet may have been protected and/or password protected.

As a strict rule,

• Don't delete or modify spreadsheet range names.
• Don't rename, hide or delete any sheets in the spreadsheet.
• Don't modify the protections employed on the spreadsheet other than via the settings macros.

As a general rule,

• Be careful when inserting columns into spreadsheets to the left of data used or manipulated by macros (other than simply sorted data).

Problem - Unable to access the Visual Basic Macro Editor.

Solution - The macros used in Business Spreadsheets Dot Com's spreadsheets are proprietary and are protected by passwords, copyright law and international treaties. Should you wish to access our Visual Basic code then please contact us for information regarding our open code policy.