Copy and Paste Special within all Worksheets

Hello Experts,

I've a folder Name "Output Files", into which I keep multiple worksheets.

Into Each worksheets there could be 3-5 tabs. So into this tabs there are some formulas.

I've a Macro file which extracts the data from 2nd tab of every worksheet and starts pasting the output into the Macro file.

But I continuously get a message box as "We can't update some of the links in your workbook right now" and "This workbook contains links to one or more external sources that could be unsafe".

Either I want this message box to get disabled OR

before running the Macro, I want some macros, which will go into "Output Files" folder and remove all formulas from all worksheets available into that folder.

Is there a way on how to achieve this ?

Thanks

This is the Code that is used to collect the data from multiple spreadsheets, which is kept in "Output Folder"

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.