Can't start on new PC

Sep 27, 2011 at 3:25 PM

First of all, many thanks for this excellent addition to Excel! I've used it for several years as OLAP cubes are used a lot where I work.

Having changed my PC, I can't get OLAP PivotTable Extensions to run. I get an error message:

http://tinypic.com/r/2j3mr09/7

I tried to re-install the add-in but still get the same error message.

Any ideas?

Coordinator
Sep 27, 2011 at 3:40 PM

That's a new bit of code in release 0.7.2. Help me troubleshoot what's going on here, please.

Open Excel (and click OK in any error messages) then press Alt+F11 then Ctrl+G. Then type the following into the Immediate Window and hit Enter:

?Application.Version

In my Excel 2010, it returns:
14.0

I'm wondering what it returns for you and why I can't parse what it returns as a decimal.

Sep 27, 2011 at 3:52 PM

12.0

I get the error messages only after I try to use OLAP PivotTable Extensions, not when I start Excel.

Coordinator
Sep 27, 2011 at 11:42 PM

Ah. You must have your language set to a language which uses commas instead of decimals. I think 12.0 couldn't be parsed because it was looking for 12,0 and gave an error.

I think changing the code from:

decimal.Parse("12.0")

to:

decimal.Parse("12.0", System.Globalization.CultureInfo.InvariantCulture.NumberFormat)

should fix the problem. Let me work on a new release with this fix. Until then, you can install release 0.7.1, or just wait.

Marked as answer by furmangg on 6/9/2014 at 4:06 PM
Coordinator
Sep 27, 2011 at 11:49 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Sep 28, 2011 at 9:21 AM

As you guessed, I use "," as decimal separator, not "."

I installed version 0.7.1 instead, it works as you expected!

Thanks for swift replies!

Coordinator
Oct 1, 2011 at 4:53 AM

I just put out release 0.7.3 which fixes this issue.

Marked as answer by furmangg on 6/9/2014 at 4:06 PM
Oct 12, 2011 at 1:18 PM

I must say that I'm extremely impressed with both this extension to Excel and the response time when there´s a problem.

Thanks!