cancel
Showing results for 
Search instead for 
Did you mean: 

Error while saving sheet options with DelayPaneUpdate=true

Former Member
0 Kudos

Hello!

Currently we have a problem with some clients and SP19. We had problems with a freezing member selector and found the note 2073553. After installing SP19 and setting DelayPaneUpdate = true, the problem is solved. But this solution comes with a new mistake .... If DelayPaneUpdate ist set to true, you can't make any changes in the Excel sheet options. After clicking "OK" an alert appears with the following error message:


Unhandled exception has occured in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.

Object reference not set to an instance of an object.

Continue ignores the error, but the changes are not set to the sheet ... For more information, I added the error details in a text file to this post.

Does anyone of you had already this error and found a solution?

Thanks in advance

Julian

Accepted Solutions (1)

Accepted Solutions (1)

former_member208963
Participant
0 Kudos

Yes it's happening to me too, SP 19 Patch 1

and i have in FPMXLClient.dll.config the:

<add key="DelayPaneUpdate" value="true"/>

I have to set it False to save sheet options...

Former Member
0 Kudos

Hello Robert,

do you found any solution? I'm in contact with the support, but they can't reproduce the error. Which Excel Version do you use?

Julian

Former Member
0 Kudos

Hi Julian,

Try the new excel add in, SP20.

Andy

Answers (0)