Hi,
I have attached a spreadsheet that has the following tabs: powerhouse report, influent clarificatioin report, and data history. The PH report and Influent report are supposed to take data from the data history tab....which is named POWER.
My problem is that the PH report does take data from the data history tab but the Influent report doesn't.Does anybody know what the problem is? Thanks!
Last edited by mufan; 01-04-2010 at 03:14 PM.
It looks like you have a different definition of the named range POWER in the two sheets...
In the Ifluent sheet, go to Insert|Name|Define and select POWER... fix it so it refers to the Data History sheet.
Then in the Influent sheet, change formula to remove the Example.xls! from the formulas.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That's it. Thanks a bunch.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks