Skip to Content
author's profile photo Former Member
0
Former Member

Can Workbook allow for drilldown if Excel cells are using formulas?

Posted on Nov 21, 2011 at 12:54 PM 10 Views

Dear Experts,

There is a complex query required that I find it can only be met by using a workbook referencing a query result in another sheet.

But I not sure can a workbook allow for drilldown without messing up the excel formulas set in the cells like KF columns or header?

I am not using hierarchy in the rows. Just plain characteristics.

The columns are FY outside the KF Columns which can vary in number of columns depending on how many FY entered by user.

Hope to get some clues.

Regards

Bass

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Kenneth Murray
    Kenneth Murray
    Posted on Nov 21, 2011 at 02:12 PM
    2

    If you are referencing specific cells then you will run into problems, but if your excel formulas refer to entire columns you should be able to work with this... good Luck

    Add a comment
    10|10000 characters needed characters exceeded

    • Kenneth Murray Former Member
      Nov 21, 2011 at 03:54 PM

      I don't know anything about BOBJ, but another thing you could do if you are creative is to use macros to find an area used in a formula and then have the macro reference this "named range".. I have a user that also has to readjust his formulas when he makes changes to his material hierarchy as well. Good Luck.

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.