Skip to Content
1
Oct 10, 2019 at 12:19 PM

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

524 Views Last edit Oct 10, 2019 at 12:27 PM 2 rev

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