Skip to Content
author's profile photo Peter Casper
0
Peter Casper

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

Posted on Oct 10, 2019 at 12:19 PM 335 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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Ivan Andreis
    Ivan Andreis
    Posted on Oct 15, 2019 at 06:47 PM
    1

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Ivan Andreis
    Ivan Andreis
    Posted on Oct 11, 2019 at 05:55 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Peter Casper
    Peter Casper
    Posted on Oct 14, 2019 at 10:57 AM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Ivan Andreis
    Ivan Andreis
    Posted on Oct 14, 2019 at 11:50 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Peter Casper
      Oct 15, 2019 at 08:32 AM

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.