InfoQube IM - Community

Submitted by martym on 2012/06/06 14:13

Team,

I've been using W10 in Portable mode to track some financial data. Tried Pivot Tables several weeks ago. Cool! Since then I added more data. Went to use the PT feature and got the error that I have no Office installed. I do, office 2007, and have for months. Nothing changed there. How do I get the capability working again? What could have made IQ think I don't have Office installed?

I'm running Windows 7 and it's locked down tighter than a drum so don't suggest I dabble in the registry.

Any help is greatly appreciated!

MartyM

Comments

Just to be sure:

When you tried Pivot Table last, was it also with W10?

If so, you'll have to wait for the experts.

If not, you could try the last IQ version that worked? (I have most recent older versions in my download folder and can upload if you need)

Tom,

Thanks for the offer. Both instances have been with the lastest W10 load. I also rebooted with no change.

MartyM

Marty,

Maybe you could send Pierre a personal message. Especially if this is crucial for your work.

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

Have you tried doing a repair of office? Perhaps something else has messed up how its registered.

Hi All,

Still looking for some help/guidance on getting Pivot Tables to work again. IQ W10 says I don't have Office installed but I do (Office 2007 Professional SP3 MSO) . I am looking for things that I can check given that I have a fully locked down PC that affords me no priviledges. I cannot reinstall Office nor can I muck with the registry. For reference, UltraRecall still finds and uses the Office components without a hitch. I am running Windows 7 SP1 Build 7601 on a HP EliteBook 8440p with 4G RAM.

Thanks,

Marty

Hi,

Have you tried installing the Office Web Components ?

http://www.microsoft.com/en-us/download/details.aspx?id=22276

The last version is 2003. These components are not included in Office 2007 and up

HTH !

[quote=Pierre_Admin]

Hi,

Have you tried installing the Office Web Components ?

http://www.microsoft.com/en-us/download/details.aspx?id=22276

The last version is 2003. These components are not included in Office 2007 and up

HTH !

[/quote]

Hi Pierre,

Thanks for the response. Unfortunately, I cannot install anything on my machine. This is the new corporate environment where security is paramount. For me to run a program, it needs to be self sufficient. My confusion is that Pivot Tables were working and then stopped for seemingly no reason. I suppose that a MS security update could have blocked access but I don't get a security warning. Just the dialog box stating that MS Office is not installed...

edit: I checked the MS Word path in the configuration settings and it is correct. MEM

Good luck on your Project,

Marty

Most likely something was changed, either through a security update or through your IT department.

Perhaps you can ask your IT department to have the OWC installed... as an to MS-Word. Requesting a license of MS Access is another way to have the OWC.

Good Luck !

BTW, another option, is to create an ODC connection and use Excel to display the pivot table. Not quite as integrated, but definitely workable.

HTH !

Pierre