Excel Worksheet refresh, remove formula and keep numeric & text values?

[natheplas]

Hi,

I've posted a similar post:

But I was wondering if it's possible to refresh a report, but when the refresh happens it removes the formulas and database links, but keeps the numeric/text values please.

For example, if A1 reads 4, but actually was =2*2, when it refreshes it will just be 4.

Another example would be B2 reads green, because it is looking at another worksheet =Sheet!A1 that says green, but when it refreshes the formula link is gone and just text as green.

Is this remotely possible, if anyone knows how or where I should start, that would be massively appreciated.

Thank you.

Natheplas

 

[Special-K99]

Copy / Paste Values ?