Formulas Not Pasting

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.

Please Login or Register  to view this content.

Hi and Thank you!

Your code partially worked. As a test, I froze my workbook, deleted the Atlanta tab, re-inserted it and unfroze the workbook. The information populated the Atlanta table of the summary page perfectly but then the tables for some of the other branches on underneath (which I didn't touch) seemed to stay frozen (in text form) (All the tables on the right were also fine).

Should I have added something to your coding or could it be the way my cell is formatted (although I double checked and compared to the cells that were ok and I don't see a connection there)?

Hi Amber

I set the macro to ignore some columns and some rows to speed things up.

Maybe I shouldn't have.

I will tweak the file and repost it for you.

BRB

Try This. I will check it myself and will come back to you if I find anything useful.

Please Login or Register  to view this content.

The macro above works for me.

But I have added a few lines to ensure that it is always working on the correct sheet.

Please Login or Register  to view this content.

That worked perfectly!

Thanks so much!