Editing single sheet of an excel

[Former Member]

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

[Juwin]

Can you change the Pivot table to take data from an external workbook? If yes, create output from program into that external workbook. So, the workbook containing pivot table will never be touched.

Thanks,

Juwin

[Former Member]

HI Juwin,

Thanks for your feedback.

If we move pivot table to different workbook and try to download an internal table to other workbook then it would be a Gui_download.

But requirement here is, based on output in Monday sheet,we will have certain calculation in other 2 sheets which are predefined formula or pivot table and store in particular path. The main objective here is to reduce/remove manual work of defining formula each and every time after downloading the output.

Please advice.

Thanks,

Naveen

[Jelena]

Google -> 'Excel single sheet site:sap.com' finds over 6000 posts. Were none of them helpful?