Object variable or With Block variable not set

[Former Member]

Hi - We have saved a working input schedule to a new name and modified it to use for another company. There is a report tab to bring down the historical units from BPC, a tab to trend the history, and a tab that references the other two tabs to forecast the units into the future and send the forecasted units back up to BPC. The input schedule that was saved to a new name and modified works fine until we attempt to Send and Refresh the active worksheet on the forecast tab. When we do so, it indicates the number of records that will be sent, but when it attempts to Process the upload to BPC we receive an error message that indicates Object variable or With Block variable not set and no records are sent to BPC.

We have retested the original input template that was copied and the original template still transfers data successfully to BPC. We have also tried starting with a blank input template and copying in the formulas from the working template and we still get the same error message.

We have read several postings on this error and it seems to be a pretty general error, and so far none of the suggestions have worked for us. One suggested checking for special characters, but the only non alpha non-numeric characters used are dashes in the values of one of the dimensions and spaces and underlines in the formulas used to forecast the units, but both of these are present and don't seem to cause any problem in the working input schedule.

We are currently on BPC 7.5 SP6 and using Excel 2010.

Any help would be appreciated.

[Former Member]

Andrea, hi!

Check note 1592560. Also read 1494285 about supporting Office 2010 (for example, support for 64-bit Office won't be available until BPC 10).

Excel sometimes disable SAP BPC addon, you must enable it, if so (note 1523379).

Also I think you should try patch your server and client. (SP09 available).

[Former Member]

Hi Anton - We already tried note 1592560 and disabling and reabling the add-on, and neither of these worked. Note 1494285 seems to be in reference to BPC for Microsoft and we are using NetWeaver. Patching our client at this time is not possible, we are the middle of a merger project and our systems are frozen for the time being.

Any other suggestions would be appreciated.

Thanks

Andrea

[Former Member]

>Note 1494285 seems to be in reference to BPC for Microsoft and we are using NetWeaver.

Sorry, 1513080 is for NW (there's link to it in bottom of 1494285) :

- Currently only BPC 7.5 NW SP05 and above support Office 2010

- Note: BPC NW 7.5 NW cannot work on office 2010 (64-bits), office 2010 (64-bits) is not supported.

Check your proxy settings (note 1592560: Getting "Error 91 Object variable or with block variable after upgrade to SP06" in the Excel Client.)

Try 1576893: After upgrading to SP06, the EVDRE reports stop working.

PS. Maybe I wrong, but some problems with 2010 Office clients in our system dissapear after patching to SP08.

[Former Member]

Hi Andrea,

Did you ever find a solution to this issue. We are having the exact same problem where we get the 'object variable or with block not set' message on save and then no records are saved. We are at a crucial stage at the moment as we go live next week and this error is appearing sporadically.

Any help would be much appreciated.

Megan