EPM Add-in for Excel 2010 & 2013 (32-bit)

[Former Member]

Hello,

Can someone advise if there is a common patch that would make EPM Add-in for MS office work for office 2010 & office 2013 both being 32-bit office clients.

Thanks,

Pratap

[Former Member · Accepted solution]

SheetN would refer to individual sheets on the workbook.

The Current report has below tabs:

Title

P&L

Revenue

Costs

Projects

[Former Member · Accepted solution]

and version.

[former_member186338 · Accepted solution]

It's better to use the following syntax:

ThisWorkbook.Worksheets("Revenue").Columns...

Etc...

[Former Member · Accepted solution]

This syntax works fine on excel 2010 with EPM Addin SP20.

But not working on EPM add-in SP 25 with Office 2013.

[former_member186338 · Accepted solution]

Try the correct syntax from my previous post!

[Former Member · Accepted solution]

Tried that but still doesn't work.

Looks like it only does the autofit for active sheet.

modified code as below:

ThisWorkbook.Sheets("Profit & Loss").Columns("J:J").AutoFit

ThisWorkbook.Sheets("Revenue").Columns("I:I").AutoFit

ThisWorkbook.Sheets("Costs").Columns("I:I").AutoFit

ThisWorkbook.Sheets("Labour Resource").Columns("H:I").AutoFit

ThisWorkbook.Sheets("Projects").Columns("H:I").AutoFit

When clicked on Profit & Loss sheet the error occurred on 2nd line for Revenue.

And If I click on Revenue sheet then error occurred on 1st line.

[former_member186338 · Accepted solution]

Just tested on EPM SP25 NET 4 with 2 sheets containing EPM reports and one Title sheet:

Function AFTER_REFRESH()

ThisWorkbook.Sheets("Revenue").Columns("I:I").AutoFit

ThisWorkbook.Sheets("Costs").Columns("I:I").AutoFit

End Function

Everything work fine! May be you have other incorrect code...

Vadim

[Former Member · Accepted solution]

On excel 2013?

[former_member186338 · Accepted solution]

On Excel 2016

There is nothing special with this particular formulas.

Vadim

[Former Member · Accepted solution]

Hi Vadim,

I am not sure what else is wrong with this. Logged a OSS call with SAP so hoping they can help me.

I have posted another regarding an issue with retrievedata. Can you please help with that.

The thread is:

Thank you,

Pratap

[former_member186338 · Accepted solution]

Try SP25 patch 3!

[Former Member · Accepted solution]

Hi Vadim,

Is this the one you are suggesting?

The description says "BIG VOL", I am not sure what does it mean.

Thank you,

Pratap

[former_member186338 · Accepted solution]

Yes, BIG VOL!

[Former Member · Accepted solution]

Hi Pratap,

BIG VOL means it supports 64bit office, it will work with 32bit office as well.

it requires .NET 4, which is much faster then .NET 3.5 version of the EPM add on.

Andy

[Former Member]

Thanks guys.

SP25 patch 3 is also not helping with Autofit error.

Looks like its issue somewhere else, may be an Office bug.

[former_member186338]

Sorry, but in my test case everything is working correctly.

Start with new report, add minimum VBA code, test!

[former_member186338]

But what is the issue you have?

Vadim

[Former Member]

I installed  EPM Add-in 10 SP25  patch 1  and report are not working.

Our reports have custom ribbons.

If I disable custom ribbons then I can refresh reports using EPM tab refresh button.

BPC 10 + Win 7  + Office 2010 32-bit

- Pratap

[former_member186338]

"Our reports have custom ribbons." and VBA code?

Not possible to help in general, you have to narrow down the issue yourself...

Vadim

[Former Member]

Hi Vadim,

Yes its a VBA code.

I installed the correct EPM patch for office 2013 and the custom ribbon has become responsive now.

But the report refresh fails in specific scenario where there are autofit for multiple sheets.

We are using the AFTER_REFRESH() function to autofit the columns.

I have observed that if a report has only one sheet then autofit method in After refresh function doesn't fail.

The error message looks like below:

The function code is as below:

Function AFTER_REFRESH()

'autofit columns after drill down on a member

ThisWorkbook.Sheets(Sheet7.Name).Columns("J:J").AutoFit

ThisWorkbook.Sheets(Sheet5.Name).Columns("I:I").AutoFit

ThisWorkbook.Sheets(Sheet1.Name).Columns("I:I").AutoFit

ThisWorkbook.Sheets(Sheet2.Name).Columns("J:I").AutoFit

ThisWorkbook.Sheets(Sheet18.Name).Columns("H:I").AutoFit

ThisWorkbook.Sheets(Sheet7.Name).Columns("J:J).AutoFit

End Function

This is not a issue in office 2010 excel.

Any advice?

Thank you,

Pratap

[former_member186338]

What do you mean by the code Sheet7.Name? What sheets do you have?