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

Editing single sheet of an excel

34 Views

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.

Thanks,

Naveen