How to remove source code, hidden links, Formula links from excel?

[Harikrishna]

Hi,


I am running a macro for data in excel but it is leaving the source code, formula links and hidden links after removing the vba script.


Can any one help me with the solution how to remove all the links from the excel becoz i am sending these files to third party where some software is detecting all the source and links in excel

Attaching file for your reference.


Thank you in Advance.

 

[bobhc]

Good day Harikrishna and welcome to the forum

If you have not already done so please read this http://chandoo.org/forum/threads/new-users-please-read.294/

As to your problem if it is just one or two sheets just copy all and paste into a new sheet as "Value"


.

 

[Harikrishna]

Thank you it worked