VBA :How to save multiple sheet into another excel file and removing formula upon saving

[JOHATUP]

I have this excel sheet: Data, Pivot, Posted sheets that I need to save in one file excluding other sheet. I was able to save the file however the formula still there upon saving, I need the data of the original file to be intact so that what will be save is the correct value/data.?

 

[JOHATUP]

The file you posted has two extensions (xlsx and xlsm) in the name so Excel doesn't recognize it. Please re-save the file with one extension only and re-post.

Dropbox

www.dropbox.com

 

[mumps]

I'm sorry but I have tried different approaches but I can't seem to find anything that works. I suspected that the pivot tables are interfering somehow. Maybe another Forum member will be able to help.

 

[JOHATUP]

I'm sorry but I have tried different approaches but I can't seem to find anything that works. I suspected that the pivot tables are interfering somehow. Maybe another Forum member will be able to help.

Can we try excluding the 2 pivot table? i mean we can save it but it can remain its formula to make it work. Is it possible?

 

[mumps]

I tried a few more approaches but I can't get it to work. Sorry.

 

[JOHATUP]

I tried a few more approaches but I can't get it to work. Sorry.

Thank you for your time, truly appreciated your effort.

 

[mumps]

My pleasure.