Issues: Difference between revisions

From Wiki for The Only Sheet
Jump to navigation Jump to search
No edit summary
 
No edit summary
Line 11: Line 11:


To change the security level of the Macros, search the help in Excel on ''macros security''.
To change the security level of the Macros, search the help in Excel on ''macros security''.
== General Errors ==
=== I defined a new weapon (armor, shield, equipment), but the Statistics do not correspond with what I entered!!? ===
Most probably, you used a name which is already assigned to another item. Make sure you are using a unique name!
== Errors on Welcome worksheet ==
===Excel tells me the Sheet is protected when I try to insert my Registration Key===
Click on the "Enter Registration Key" button and paste your Key in that box! Note that Macros are essential to the Sheet. If you do not activate them, The Sheet will not function properly.
== Errors on FRONT worksheet ==
=== When I select a Weapon, its name becomes RED ===
If you select a Range weapon and use it as a Melee weapon, you will get this condition. Make sure the [[Front_Worksheet#The_Attack_mode|mode of attack]] matches the type of weapon.
== Errors on the BACK worksheet ==
=== On the back Sheet, I have many #N/A in the Skills I selected for my character ===
Most likely, you have used a "section" title in the Class, instead of a Valid Class Name. The section titles are only present in the list box to break the class listing into sections. So things like '''"-[ CORE CLASS ]-''' should NOT be selected as a class!!

Revision as of 08:54, 5 June 2007

This section is intended to help users fix problems they might encounter with TOS+

Software Errors

Excel Crash when opening TOS+

TOS+ requires the latest Service Pack for Microsoft Excel. This is true from Excel 2000 to Excel 2003. To check if you have the latest Service Pack, open excel, and choose HELP->Check for Updates.

You can also update Excel manually if you download the latest Service Pack from the Microsoft website. Search for Excel 2003 Service Pack to find those for Excel 2003.

Ofter opening, many cells show #NAME or ####

When you open TOS+, you are required to activate macros. Macros are actually the code that has been added to TOS+ to make it work properly - like any piece of software, the Sheet needs to be executed to access all the special functions that makes it work.

To change the security level of the Macros, search the help in Excel on macros security.


General Errors

I defined a new weapon (armor, shield, equipment), but the Statistics do not correspond with what I entered!!?

Most probably, you used a name which is already assigned to another item. Make sure you are using a unique name!


Errors on Welcome worksheet

Excel tells me the Sheet is protected when I try to insert my Registration Key

Click on the "Enter Registration Key" button and paste your Key in that box! Note that Macros are essential to the Sheet. If you do not activate them, The Sheet will not function properly.


Errors on FRONT worksheet

When I select a Weapon, its name becomes RED

If you select a Range weapon and use it as a Melee weapon, you will get this condition. Make sure the mode of attack matches the type of weapon.


Errors on the BACK worksheet

On the back Sheet, I have many #N/A in the Skills I selected for my character

Most likely, you have used a "section" title in the Class, instead of a Valid Class Name. The section titles are only present in the list box to break the class listing into sections. So things like "-[ CORE CLASS ]- should NOT be selected as a class!!