cancel
Showing results for 
Search instead for 
Did you mean: 

Loosing Planning View Connection

marc_laberge
Participant
0 Kudos

Hi,

I have a new bug since this afternoon.

For now it seems to affect just me (not my coworker that has the same Excel & IBP Add-In versions).

I load a template, I start changing values / settings ... and suddenly Excel looses all reference that the sheet is a planning view.

If I click on Simulate / Save / Refresh nothing happens.

If I click on Planning View, I get a blank screen:

If I try to update or create a template I get the error message: To add a template, the active worksheet must be a planning view.

I've tried with plugin version 5.0.6.0 & 5.0.7.0 both on Excel 2013 (whick I downgraded to yesterday from 2016 in order to update my plugin version).

This happens if I open from a template or if I try to create a new planning view from SAP's default Excel files or a blank file.

What could be causing this !?

Thanks,

Marc

Accepted Solutions (0)

Answers (3)

Answers (3)

marc_laberge
Participant
0 Kudos

Hi,

No I haven't tried that.

Will do once I get office and add-in installed again.

I removed everything once more !

Irmi_Kuntze
Advisor
Advisor
0 Kudos

ok, last trial before I recommend to through your computer out of the window ...

Did you try to log on on your laptop with your colleagues user, and vice versa?

In which of the two cases do you get the error?

If it is Computer-related, you may delete your settings and copy those from him/her (files under C:\Users\<your user ID>\AppData\Local\EPMOfficeClient , but make a backup first especially of the connection file)

If it is user related, you either create yourselve another user or you open up an OSS message

marc_laberge
Participant
0 Kudos

No luck ...

No idea what is causing this.

I've tried it all ...

marc_laberge
Participant
0 Kudos

The issue seems to arise when I get this error message in the Add-In log:

2016-02-17 16:29:15,897|ERROR|UILayer|?.?|a-marlaber|||||7|From S&OP: Removing workbook with report ID ce8cf04315154457a87b5b948e07ddff from buffer#

Irmi_Kuntze
Advisor
Advisor
0 Kudos

Dear Marc

Did you try to delete the meta data?

(In the logon, mark your connection and click EDIT -> delete meta data , or go in windows explorer path

C:\Users\<your user ID>\AppData\Local\EPMOfficeClient\Metadata

and delete all file in that folder)

???

Did you try to create a new planninig view based on a Template?

(In excel, have a fresh sheet, click on "New View" -> From Template)

Did you try to create a new planning view from scretch?

(In excel, have a fresh sheet, click on "New View" -> Without Template On current Sheet")

Try if some of these would help to identify the issue more detailed

Irmi

marc_laberge
Participant
0 Kudos

Hi,

I've tried all 3 views, from template, from Excel file from SAP and a blank page.

And i tried to clean the cache.

Same results.