Skip to Content
Former Member
Jun 24, 2015 at 04:00 PM

Editing single sheet of an excel


Hi Experts,

I have requirement where i need to edit single sheet in excel.

Let us take an example, we have excel by name 'WEEK' and stored in predefined path.

The "WEEK" excel have multiple sheets called 'MONDAY', 'TUESDAY' and 'WEDNESDAY'. where as 'TUESDAY' and 'WEDNESDAY' has a predefined pivot table. Every time when I run a report the output should download only in 'MONDAY' Sheet , where as 'TUESDAY' and 'WEDNESDAY' should not be altered.

I tried transformation techinque but its affecting the 'TUESDAY' and 'WEDNESDAY' sheet as well.

Please suggest.