Hi Thank you for replying,
I tried that before when I take the data out I no longer have the issue because formulas are not re calculating when I change a cell. Maybe I can explain the issue I am having better.
So basically I have a macro to hide or unhide pages right. Once I run this macro when ever I change any cell on any page (keep in mind all cells are somehow connected to cells on other pages through formulas and lookups). When I change any cell random pages that are hidden just seem to pop up on the worksheet like multiple pages at once in a huge mess and I have to go to another page to make it go away. Has anyone ever had a similar problem?
Thank you,
Your friend