Table of Contents

Troubleshooting: Paste error when editing map value rule in Excel

Symptom

A developer asks:

I was building a map value rule. When I tried to edit in Excel and paste a column of values in, I received a message indicating that the spreadsheet was protected, and I was prompted for the password.

I have 300+ rows that I need to paste.   How can I do this?

Solution

Explanation

This is logged as bug B-17107

Update: This issue is resolved in V42SP6.

Workaround

It is a bad idea to try to unlock the password.  Here are some workarounds:

  • If you are copying from within the map, you can do a drag/drop (with the ctrl key held down).
  • Display the clipboard (Edit Menu/Office Clipboard) and paste from there-- beware that it is possible to copy data past the default row or column from the clipboard (also a bug to be addressed).

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.