Comments on Frederik Vandeputte: The connection in this workbook will no longer be ...

Thank you very much for this post. It has saved m...

2010-12-16T20:59:36.063+01:00

Thank you very much for this post. It has saved me hours if not days of frustration.

Hi, In know it's an old post, but i've fo...

2009-11-27T12:54:54.993+01:00

Hi,

In know it's an old post, but i've found a problem related to it... hope you can help.

If I create a new ODC (analysis services connection), Excel 2007 shows the measures as formatted in the cube properties. The ODC "connection properties" dialog shows, under the Usage tab, all the "OLAP Server Formatting" ticks are CHECKED. OK so far.

Then I upload the ODC to a sharepoint data connection library.

The problem is, when I open the ODC from sharepoint to an Excel worksheet, measures are shown without format. If, again, I open the ODC's "connection properties" dialog, all the "OLAP Server Formatting" ticks are UNCHECKED. If I recheck the "Number Format", everything works fine again...

Do somebody know why are those checks changed?? Is it a property of the ODC, or of the Excel file?? I've googled it a lot.. with no results...

Thanks!

Cheers mate!

2009-04-14T14:00:00.000+02:00

Cheers mate!

This was driving me crazy. Thanks for the info.

2009-02-01T15:12:00.000+01:00

This was driving me crazy. Thanks for the info.

Thank you so much. I was going around in circles t...

2008-11-17T20:38:00.000+01:00

Thank you so much. I was going around in circles trying to figure out what was going on with this. You saved the day for me.

Thank you. I wouldn't have thought about this.

2008-07-21T08:42:00.000+02:00

Thank you. I wouldn't have thought about this.