Copying the values only while making new excel file from an existing excel file

Topics: Developer Forum, Project Management Forum, User Forum
May 29, 2014 at 10:12 AM

I am having an Excel File which has got some cells linked to other sheets in other files.

While I am cloning the Excel Worksheet it is returning a 0 value into the cells which are getting the values from the linked cells in the other sheets in the other files.

Is there an option where I can copy only the values from the Excel Worksheet to create a worksheet having all the values.

Please reply.