Hello

I have recently been investigating an issue in Excel where Excel would crash when certain CUBEVALUE functions were entered.

We eventually worked it out to be using a reference to cells in an external Excel spreadsheet (on a SharePoint intranet site) as the member expressions.

e.g.

=CUBEVALUE("MyCube",='http://<URL>/[<spreadsheet_name>.xlsm]Source'!$C$11)

will always cause Excel 2007 to crash (for the patch level we use anyway - SP2).

My question is, is it possible, or should it be possible to do the above?

Thanks

Rog


For further info...

"MyCube" is a valid SSAS cube connection and works ok for basic CUBEVALUE functions.

='http://<URL>/[<spreadsheet_name>.xlsm]Source'!$C$11

in a cell in the same spreadsheet resolves to a valid entry for a member expression (typing in the member expression the same as what it resolves to works ok).

Excel has an exception at the point of accepting the entry into the cell, a SQL profiler trace shows that the connection doesn't get established to the OLAP cube.

When Excel crashes we get the "Excel needs to close" Dr Watson error and the following generic Excel crash is logged in the Windows Event Viewer Application Log:


Event Type: Error
Event Source: Microsoft Office 12
Event Category: None
Event ID: 1000
Date: 02/09/2011
Time: 13:49:31
User: N/A
Computer: TSGD40
Description:
Faulting application excel.exe, version 12.0.6425.1000, stamp 49d64dd6, faulting module excel.exe, version 12.0.6425.1000, stamp 49d64dd6, debug? 0, fault address 0x00612a23.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Have also applied hotfix:
http://support.microsoft.com/kb/2412271
but the exact same behaviour still occurs.

Thanks