Need to add registry key to excel 2003...how? 1

[scotton]

I saw on here an old post regarding the nested subtotaling issue with microsoft excel 2003. Here is part of the old post:

I got in contact with Microsoft and there is a fix for this that requires an update to the registry to tell Excel 2003 to use the Excel 97 subtotal method since the new code subtotals incorrectly. I updated my registry and the subtotaling now works. The registry entry thatneeds to be added is:



Add the following registry key to -
HKEY_CURRENT_USER\software\microsoft\office\11\excel\options

Dword = Excel97Subtotals

Value = 1

Be sure to backup the registry before updating.

Regards
Ken..............

How do I add the registry key to my stand alone pc and what do I do to back up everything ?

TIA,

Sarah

 

[fredericofonseca]

for such a small change I would not create a backup.

One option is to start regedit
(menu start, run, type "regedit" and hit enter) (do not put the quotes!!)

browse until you are on the correct branch, e.g.
HKEY_CURRENT_USER\software\microsoft\office\11\excel\options

On the right side, right click and select new->Dword from the menu.
As the name of the entry type
Excel97Subtotals
and hit enter.
Now double cliek on the newly created entry and change the value to 1.

or if you have Windows XP you can do it the following way.

Open Notepad, and add the following lines to it.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options]
"Excel97Subtotals"=dword:00000001

Save it into your desktop. name it excel_calc.reg.

If the file has been created as ".txt" rename it again to ".reg".

Double click on it and respond yes to the questions that will show up.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com