Skip to Content
0
Former Member
Apr 09, 2009 at 04:38 PM

EVGTS to get data from multi-applications in a workbook of multi-worksheet?

51 Views

Dear all:

Situation

I am trying to build a financial report that consists of:

1. Balance Sheet (Finance App)

2. Profit and Loss (Finance App)

3. Sales Analysis (Sales App)

4. Inventory Flow (Sales App)

5. Expense Report (Finance App)

Basically, I need the data from No.2 to No. 5 to get No.1 Balance Sheet.

Problem

When I refreshed or expanded the entire workbook, sometimes the other application's EVGTS would not get refreshed, and the cells either showed 0 or #RFR.

Question

1. For my EVGTS, I noticed that for the dimensions shared by both Finance and Sales Applications, I didn't include those members in my function. Could this be the reason? But I thought EVGTS would fill in the missing memebers directly from the Current View, or it has the limitation to one single Application?

2. Also, EVGTS sometimes seems to refresh itself upon any change in my current view, and sometimes not. What is causing this behavior?

Thank you!

Have a nice long weekend to some of you...

Brian