Dynamic QlikView Reports in MS Office Docs

[#1]

Hello,

I was given a demonstration of functionality whereby a QlikView object such as a chart could be dragged and dropped into an MS Office document and then the report is able to be updated dynamically within the MS Office.

I've tried replicating that functionality myself but it doesn't currently work.

What setup such as Excel add-ins etc do I need to complete to get this to work? (I'm on V10.0)

Thanks

[danielrozental]

I'm not an expert at this but I believe you need to have the QlikView OCX installed for it to work.

[#3]

Thanks Daniel - I'll take a look at that

Scott Beange

Project Manager, CDO

Royal Bank of Scotland Group

Strategy & Architecture

149 Preston Rd, Brighton, BN1 6AS, UK

Office: +44 (0)1273 543 171 | Internal 23543171 | Mobile: +44 (0)7867

800 947

Email: scott.beange@rbs.co.uk

[rustyfishbones]

Hi Scott,

What I did to get this to work, I right clicked on a Qlikview Object like this

I then opened an Excel spreadsheet and and right clicked like this and hit Paste Special

I was then asked to choose to paste as, I chose HTML and clicked OK, and that worked

[#5]

Thanks Allan, that is useful to know.

I think the issue in my case may relate to the fact we're not yet

running QlikView on the Enterprise Server and that we need certain

services running in order to embed the objects in the MS Office docs.

Best regards

Scott

[rustyfishbones]

Hi Scott,

It works for me and I am using a single license, no Enterprise server, no Small Businees Edition Server and no Publisher

Regards

Al

[#7]

Thanks Alan, that's good to know.

[#8]

Hi Alan,

I meant to ask what version are you on?

Best regards

Scott

[rustyfishbones]

Hi Scott,

QlikView 11.20 SR2

Regards

Alan