BPC10 NW - Link BPC report to Excel Worksheet

Hello Gurus,

I am having an issue with linking a report in BPC 10 NW.

In an excel workbook, I have a BPC report in the first tab. In the second tab, I have excel formulas such as "=A2", etc. that refer to the data in the first tab. However, when I refresh the BPC report, the data in the second tab disappears and I get a "#REF!" error. I am not sure if I am configuring the data links, member links, etc. correctly.

I request your expert guidance to troubleshoot this issue.

Thanks for all your help.

Regards...