All,
I have a file that I run daily that has a large number of indirects as the back end - something like 3-400. I have a basic paste value macro that I run and send out the ranged valued version of the file. The problem is, the file, despite being range valued, is 3MB every time, despite only being a few worksheets. It's like there is a data signature that is holding on and keeping the file size large. Can anyone suggest a way to sort of let that signature go?
Thanks