CAUTION - Copy/Past...
 
Notifications
Clear all

CAUTION - Copy/Paste from PRC

 

Bob James
(@bo3b)
Eminent Member Customer
Joined: 4 months ago
Posts: 22
Topic starter  

Just encountered a strange situation that can potentially create problems beyond PRC.

Page 13 of User Manual cautions against Copy|Cut->Paste WITHIN or TO PRC but AFAIK makes no mention of Copy|Cut->Paste from PRC to another workbook. And page 182 covers "Configuring Excel" which suggests that other worksheets use is valid if PRC is launched first - And this caveat was followed in the situation below.

Selected a Table within PRC (Asset Classes ROR), Copied and pasted into specific Sheet of an independent Excel Workbook with multiple Sheets. Appears that this action has caused ALL sheets within the external Workbook to become "Protected", no cells can be entered into or altered on ANY sheet, and therefore the entire Workbook becomes unusable w/o password.

Bob

PRC2022.2.26
Windows 10 Home 64-bit Version: 19042.1526
Microsoft Office Professional Plus 2013
HP Spectre x360 Laptop w/16 GB


Quote
NC Cpl
(@nc-cpl)
Trusted Member Customer
Joined: 11 months ago
Posts: 98
 

Did you select "paste all" or just the numbers? If you paste everything copied from the cell it likely brought over the formulas as well, and not being in PRC, was a mess.


ReplyQuote
Bob James
(@bo3b)
Eminent Member Customer
Joined: 4 months ago
Posts: 22
Topic starter  

@nc-cpl Sorry, don't specifically recall "Paste" method but typically "only numbers' - In any case, AFAIAK, Paste criteria should not affect Workbook/Worksheet(s) status.


ReplyQuote
Share: