21:46 - Erik M. ...so that at least all references are in the same FILE, but not on the same sheet. Changing all that is way too time-consuming, so I just accept it's not possible. Or at least, I don't think it's possible.
21:40 - Erik M. To answer your questions, I tried to change the cell references. I like all my references in one sheet, and I don't want references in another file. So now I just copy the sheet I want + reference sheet to the file...
21:36 - Erik M. No, I have lots of different files with mass balances of different process configurations. Sometimes I need to combine sheets from different files, which at first I had problems with, but now not so much anymore.
21:27 - Erik M. Well, I work with Excel a lot as well for my job, so I've already learned a lot. But seeing as I'm a process engineer, I'm not sure whether you could help me. I mainly set up mass balances in Excel and do lots of calculations.
21:25 - Jaeryd17 What kind of formula changes are you trying to make? Changing the reference to a different file name, or just changing cell references?
21:13 - Zaphod Jooe, [link] You'll probably like this.