Hi amber
Save your workbook before trying this. Don't change the name of "BUSA Org Chart Summary P7 2013 ".
By pasting over your existing data you are breaking the links in the formulae and corrupting them.
The Freeze macro below freezes all your formulae by converting them to text. Unfreeze restores them.
Try freezing your workbook before pasting your data. and then unfreezing it.
I assume you know how to run a macro.
[ Click on developer, then on macro, select the macro, click on run. ]
Good Luck.
Bookmarks