Excel help! - copying and cell references
So I could use some help from any and all excel nerds, currently working with 3 copies of one excel databook and I now need to combine these 3 into 1. Most things aren't too difficult to copy over since you can just control f -> replace abc.xlsx so that cells no longer reference the other databook, EXCEPT for fucking graphs.
Excels find function for whatever reason doesn't search within graph references and so I have to manually change each formula so that it references the cells within that databook. On top of that the formatting is somehow connected to the databook that it was copied over from so if I break all external links the formatting changes...
Anyone know of an efficient way to do this?