Hi

Is there a way to Paste values of certain formula only?

EG I have formula that link to a system but when I use the spreadsheet outside of the system environment i get #values.
I usually paste special the whole workbook, however is there a way to keep normal excel formula and only paste certain formula?

I can't define ranges are there are too many and always changing

thanks