dependency

Hello MrExcel gurus, The title of this post has the jist of my question, but here's a bit of background: I'm trying to optimize a very bulky financial model. I've got calculation time down to a couple seconds or so, but I'd like to isolate the specific cells whose calculations are still...

Hi Everyone, I'm putting toghther a very simple Gantt chart for a project. I have 6 different parts to the project. each part is seperated by a Project Number so project 1 has 1, 1.1, 1.2, 1.3 etc. The project numbers are in Column C In Column D I have start date of the projects and in Column E...

Hello I have a data model/PowerPivot, which I have been using for few months and all was working well until this morning. All of the sudden I have a number of measures that worked well last week but today come up with an error: "dependency error in the measure" even though I have not changed...

Hi all, I have an Excel challenge which I cannot get my head around. I have a planning sheet with multiple tasks and duration, which all have a start and end date. However. Some of the tasks are dependent on others. In other words: the start date of a task X could be dependent of task Y...

hi, i have a workbook with 20 worksheets. Each worksheets has formulas, using the data from other tabs, so there is a dependency between all sheets. is there a way i can create a map/flow chart diagram to show this (sheet/tab wise, how data is flowing or being used) vik

I was going to quickly mock up some logic in excel for another project I'm working on and ran into a problem I cant solve without creating dependency loops. I'm looking for a less than comparison with a bias: =IF(X1"<"Y1,1,0) and would remain true until: =IF(X1">"Y1+B1,1,0) Here is as close as...

Hey everyone, I have a question related to this I’m wondering if you could help me with. I’d like to make a drop down list that’s dependent on the number of spots available, for example for a cinema. Let’s say there are three movies playing (movie A, movie B, and movie C), with 10 tickets...

I am trying to create a dynamic table display so this is how it should work: choose drop down 1 -> choose drop down 2 -> choose drop down 3 -> show table (already made, located in another sheet) the drop downs always stay the same (no dependencies on each other) but the table will be different...

I apologize if this is a simple question, but it's just got me stumped: 1) I am building a workbook of financial data (Don.xls), and to save time, I've copied a worksheet from a master file (Bar.xls - the sheet is named "model"). 2) After I've linked all my data from the "model" worksheet...