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.?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA :How to save multiple sheet into another excel file and removing formula upon saving
- Thread starter JOHATUP
- Start date
Excel Facts
When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
mumps
Well-known Member
- Joined
- Apr 11, 2012
- Messages
- 14,012
- Office Version
- 365
- 2010
- Platform
- Windows
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. 
Upvote
0
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?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.
Upvote
0
Thank you for your time, truly appreciated your effort.
Upvote
0
Similar threads
- Question
