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.
21:04 - Erik M. Well, those #DIV/0 can be undone though, but once a cell has #REF! in it, you're screwed unless you didn't save the file, because a simple Crtl + Z doesn't undo it, hahaha. And don't get me started on those circular references...
Industrial death metallers The Project Hate MCMXCIX's new album Bleeding The New Apocalypse (Cum Victriciis In Manibus Armis) will hit the stores on next February 14th (one day later in the US).
Bleeding The New Apocalypse (Cum Victriciis In Manibus Armis) [cover art] tracklist:
01. Iesus Nazarenus, Servus Mei
02. They Shall All Be Witnesses
03. A Revelation Of Desecrated Heavens
04. Summoning Majestic War
05. The Serpent Crowning Ritual
06. Bring Forth Purgatory
"So, you have digested the title for a while", mainman Lord K. Philipson comments. "Now it's time for the cover. Artist Marko Saarelainen (who you all should hire to do your artwork or websites by the way) has once again dug deep into his disturbed mind and fired up an incredibly fitting work of art to go with the title. Just look at it, check out all the small details and have the title in mind... Taste it... Bleeding The New Apocalypse (Cum Victriciis In Manibus Armis)... That's what you are in for this time. The darkness of the music on this piece is perfectly reflected in Marko's artwork. There is a slight twist to this cover, perhaps you will see it, perhaps you won't. Just acknowledge the fact that in a bunch of weeks you will have the chance to support The Hate and Season Of Mist by actually buying this masterpiece and go thru the incredibly good looking booklet that comes with it. Marko's outdone himself in that area as well, not just with the cover As Dark Angel once put it... Darkness descends. You are now beginning to watch it, piece by piece."