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
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
