Hi I upgraded from 32bit to 64bit excel and now I get this message, I know its a reg key issue but I wondered if you have any tips? I couldn't copy and paste the text so I have attached as image.
Excel registry Key issue
It can sometimes it's can be because you've trialled a newer version of Excel on that machine before using an older one.
Or the 64bit version and the PC hasn't registered it properly, the only thing to do is a repair install of Excel and if that doesn't work you may have to reinstall the 32bit version of it.
Or the 64bit version and the PC hasn't registered it properly, the only thing to do is a repair install of Excel and if that doesn't work you may have to reinstall the 32bit version of it.
Thanks Dallas Just putting a full solution in case anyone else experiences this:
The above error is a registry key issue so you need to open Registry Editor look up the 8 digit code "000208D5" in my case the closest key reference was in Computer\HKEY_CLASSES_ROOT\TypeLib\
Note the key you need to find may not match the full exact reference in the error message, I found it was more of a guide than x marks the exact problem spot!
The closest key I had was named Computer\HKEY_CLASSES_ROOT\TypeLib\00020802
Now you need to find and delete the win32 registry keys for Excel, you can Export them to a folder for safety first if you are worried about just deleting them.
Even after uninstalling Office twice and using CCleaner to clean my registry three times, CCleaner doesn't seem to get everything in one run probably because some things are linked, I had two versions of registry keys in a couple of places:
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020802-0000-0000-C000-000000000046}\1.9\0\Win32
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020802-0000-0000-C000-000000000046}\1.9\0\Win64
and
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.9\0\Win32
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.9\0\Win64
If you want to use 64bit Excel after installing it then you would delete the Excel registry keys ending in \Win32 if any are left behind - so you leave the keys ending Win 64 and delete:
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020802-0000-0000-C000-000000000046}\1.9\0\Win32
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.9\0\Win32
I think the operating system uses the first key listed in the latest version (1.9 in the above lines is for Office 365, you may have 1.7 or 1.8 same theory applies if you have earlier Excel versions).
Once all the 1.9\0\Win32 keys are gone Excel will work in 64bit with BA. I just had to get rid of these two (other errors may have more keys to be found). I still got the same error message even when I had corrected the first win32 key, it only stopped after deleting the second key so just use that 8 digit reference as a starting point and look inside keys nearby that have similar 8 digit references and for keys named ....\1.9\0\.
If anybody has this problem in the future and finds they have to delete other key references as well maybe put those in this post to save others hunting for Excel keys
The above error is a registry key issue so you need to open Registry Editor look up the 8 digit code "000208D5" in my case the closest key reference was in Computer\HKEY_CLASSES_ROOT\TypeLib\
Note the key you need to find may not match the full exact reference in the error message, I found it was more of a guide than x marks the exact problem spot!
The closest key I had was named Computer\HKEY_CLASSES_ROOT\TypeLib\00020802
Now you need to find and delete the win32 registry keys for Excel, you can Export them to a folder for safety first if you are worried about just deleting them.
Even after uninstalling Office twice and using CCleaner to clean my registry three times, CCleaner doesn't seem to get everything in one run probably because some things are linked, I had two versions of registry keys in a couple of places:
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020802-0000-0000-C000-000000000046}\1.9\0\Win32
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020802-0000-0000-C000-000000000046}\1.9\0\Win64
and
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.9\0\Win32
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.9\0\Win64
If you want to use 64bit Excel after installing it then you would delete the Excel registry keys ending in \Win32 if any are left behind - so you leave the keys ending Win 64 and delete:
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020802-0000-0000-C000-000000000046}\1.9\0\Win32
Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.9\0\Win32
I think the operating system uses the first key listed in the latest version (1.9 in the above lines is for Office 365, you may have 1.7 or 1.8 same theory applies if you have earlier Excel versions).
Once all the 1.9\0\Win32 keys are gone Excel will work in 64bit with BA. I just had to get rid of these two (other errors may have more keys to be found). I still got the same error message even when I had corrected the first win32 key, it only stopped after deleting the second key so just use that 8 digit reference as a starting point and look inside keys nearby that have similar 8 digit references and for keys named ....\1.9\0\.
If anybody has this problem in the future and finds they have to delete other key references as well maybe put those in this post to save others hunting for Excel keys