Skip to Content
avatar image
Former Member

BPC 10 refresh issues in VBA Macro. Not updating context member when refreshing

We have a macro setup to run P&Ls for all our profit centers. The macro switches the profit center in the context and then does a workbook refresh, paste values the file, and then saves. In the past 2 months we've had an issue where even though the context is being updated with the profit center we want to run the template is refreshing a profit center that is not even within the list that we are running. Which has us ending up with a bunch of excel reports with the same data saved for each one and having to rerun. What would cause BPC to pull a profit center that is not in our list and have that be applied to our template? Is there a cache refresh or something else needed before we start our run?

I believe they are running SP26_patch3

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 09, 2017 at 03:29 PM

    Sorry, but it's impossible to discuss the VBA macro issue without providing full code.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      We actually figured out that it was an issue with a group of our servers. Thanks for your response though.