IBP Excel: Copy & paste in Excel template with multiple tabs (EPM formatted)

[peter_casper]

Dear community,

I face an issue copying and pasting values from one tab to another within an EPM foramtted Excel template.

1. Starting base is the standard EPM formatted Excel template ChartVBA_Embedded.xlsm w/ 2 sheets
2. Configure planning views and load data
3. Copy data from sheet 1 via CTRL+C
4. Switching to sheet2
5. Short calculation break (although data is already loaded for sheet2)
6. Trying to paste the data via CTRL+ V

Result: Pasting not possible due to standard Excel behaviour that it drops clipboard content in case any interaction happens in between copy and paste procedure.

This does not happen in case no EPM formatting is applied.

Does anyone know how to overcome this behaviour?

Best regards, Peter

[former_member194529 · Accepted solution]

Hi Peter,

Yes, I could reproduce the same just now with the Embedded version, and Excel really blocks the Paste menu once we alternate from worksheets.

As I use a software called Ditto, I could see that the content is successfully copied to the Clipboard and stays captured there for use, but with only Excel Native functions this behavior really disturbs a bit.

Cheers,

Ivan

[peter_casper · Accepted solution]

Hi Ivan,

it seems that there is most likely no chance to overcome this behaviour.

Best regards, Peter

[former_member194529]

Hi Peter,

Yep, that made it more clear, thanks.

I would say that another possibility is to check that there is no macro running in the target workbook or worksheet when it is activated. Look for code in the ThisWorkbook module and any other worksheet module in the target workbook's VBA project. If you do find a macro there, then it could be that the macro is altering what is in the Clipboard or clearing it out entirely.

Best regards,

Ivan

[peter_casper]

Hi Ivan,

the provided standard template "ChartVBA_Embedded.xlsm" actually contains quite a few macros/VBA already. So you're asumption is probably correct that one or another coding snippet is forcing the clipboard refresh. In essence this means that the provided standard template does not support direct copy and paste from one sheet to another one.

Not ideal but there seems to be no way to work around w/o VBA code adjustments.

best regards, Peter

[peter_casper]

Hi Ivan,

I just made selections for the 2 standard tabs available in the named template and loaded the data afterwards, i.e. switching to tab 1 first and afterwards to tab 2. So far only data has been loaded but no further steps have been applied. If I now copy some data from sheet 1 into the clipboard and switiching to sheet 2 in order to paste it somewhere, the clipboard is empty and nothing can be pasted.

The short "calculation break" is just an obeservation which I made based on the appearing Windows ring. Based on my experience Excel usually skips the clipboard content being filled out of Excel in case anything happens in between the copy and the paste step.

But in essence the problem is that I can't copy content from one tab into another one of the same Excel when I use the standard EPM template.

I hope this made the effect more clear.

Best regards, Peter

[former_member194529]

Hi Peter,

I didn't see this happening in real-time as of now. What exactly do you mean by a "Short calculation break (although data is already loaded for sheet2)" ? Which Excel action does that refer to?

Best,

Ivan