Issues: Difference between revisions
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
== 1- Software Errors == | == 1- Software Errors == | ||
=== Excel Crash when opening TOS+ === | === 1.1-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. | '''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 [http://www.microsoft.com Microsoft] website. Search for ''Excel 2003 Service Pack'' to find those for Excel 2003. | You can also update Excel manually if you download the latest Service Pack from the [http://www.microsoft.com Microsoft] website. Search for ''Excel 2003 Service Pack'' to find those for Excel 2003. | ||
===Error: 'Object library invalid or contains references to object definitions that could not be found' === | === 1.2- Error: 'Object library invalid or contains references to object definitions that could not be found' === | ||
'''32 bits version of Excel''': | '''32 bits version of Excel''': | ||
On April 11th, 2012, Microsoft released a security update which breaks the .EXD files on an existing installation. When The Sheet is opened, this error will appear. To solve this, you need to remove ALL the .EXD files on your computer - Excel will re-create them itself as required ([http://theonlysheet.com/community/viewtopic.php?f=12&t=9064 reference]) | On April 11th, 2012, Microsoft released a security update which breaks the .EXD files on an existing installation. When The Sheet is opened, this error will appear. To solve this, you need to remove ALL the .EXD files on your computer - Excel will re-create them itself as required ([http://theonlysheet.com/community/viewtopic.php?f=12&t=9064 reference]) | ||
| Line 14: | Line 14: | ||
If you use the 64 bits version of Excel, then you need to use the 64 bits version of the Sheet. Both standard version and the 64 bits version of the Sheet are posted in the Download section of the community forum. On Excel 64 bits, this is cause because Microsoft decided to abandon the TreeView control, which is used for the Quick Pick feature in the Sheet! See the '''ReadMe_EXCEL2010-64Bits.htm''' file (included with the 64 bits version of the Sheet) for more details. | If you use the 64 bits version of Excel, then you need to use the 64 bits version of the Sheet. Both standard version and the 64 bits version of the Sheet are posted in the Download section of the community forum. On Excel 64 bits, this is cause because Microsoft decided to abandon the TreeView control, which is used for the Quick Pick feature in the Sheet! See the '''ReadMe_EXCEL2010-64Bits.htm''' file (included with the 64 bits version of the Sheet) for more details. | ||
=== Ofter opening, many cells show #NAME or #### === | === 1.3- 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. | 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. | ||
| Line 20: | Line 20: | ||
== 2- General Errors == | == 2- General Errors == | ||
=== I defined a new weapon (armor, shield, equipment), but the Statistics do not correspond with what I entered!!? === | === 2.1- 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! | Most probably, you used a name which is already assigned to another item. Make sure you are using a unique name! | ||
== 3- Errors on Welcome worksheet == | == 3- Errors on Welcome worksheet == | ||
===Excel tells me the Sheet is protected when I try to insert my Registration Key=== | === 3.1- 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. | 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. | ||
== 4- Errors on FRONT worksheet == | == 4- Errors on FRONT worksheet == | ||
=== When I select a Weapon, its name becomes RED === | === 4.1- 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. | 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. | ||
== 5- Errors on the BACK worksheet == | == 5- Errors on the BACK worksheet == | ||
=== On the back Sheet, I have many #N/A in the Skills I selected for my character === | === 5.1- 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!! | 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 16:14, 13 April 2012
This section is intended to help users fix problems they might encounter with TOS+
1- Software Errors
1.1-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.
1.2- Error: 'Object library invalid or contains references to object definitions that could not be found'
32 bits version of Excel: On April 11th, 2012, Microsoft released a security update which breaks the .EXD files on an existing installation. When The Sheet is opened, this error will appear. To solve this, you need to remove ALL the .EXD files on your computer - Excel will re-create them itself as required (reference)
64 bits version of Excel: If you use the 64 bits version of Excel, then you need to use the 64 bits version of the Sheet. Both standard version and the 64 bits version of the Sheet are posted in the Download section of the community forum. On Excel 64 bits, this is cause because Microsoft decided to abandon the TreeView control, which is used for the Quick Pick feature in the Sheet! See the ReadMe_EXCEL2010-64Bits.htm file (included with the 64 bits version of the Sheet) for more details.
1.3- 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.
2- General Errors
2.1- 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!
3- Errors on Welcome worksheet
3.1- 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.
4- Errors on FRONT worksheet
4.1- 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.
5- Errors on the BACK worksheet
5.1- 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!!