Skip to Content
0
Former Member
Dec 13, 2011 at 08:55 PM

BPC 7.5NW External Data Links

37 Views

Hi All u2013

This question is in regards to a BPC 7.5 NW (SP8) input schedule stored in BPC with externally linked MS Excel 2007 spreadsheets stored outside BPC.

I have built an input schedule (which is stored in a team folder) and linked external excel spreadsheets into the schedule. My EVDRE is in Sheet1. Sheets2 u2013 5 contain the links to my non-BPC workbooks.

My problem is that when I use the u201CSend and Refresh Schedulesu201D u2013 u201CActive worksheetu201D, multiple windows pop-up for updating the links in the non-active (external data linked) worksheets. Does anyone have a better way to link data external to BPC in a schedule or report? If not, is there a way to stop these pop-ups?

Thank you!