There is no option to paste values, but there is one to Match Destination Format and selecting that will usually resolve the problem.
Alternatively, the message can appear when the data being pasted contains more rows than the journal currently has in it (35 rows by default limit) and it is therefore trying to paste into cells below the bottom of the journal, which are password protected.
In order to resolve this, start with a new Upload Journal Template and add more rows before pasting in the data.
There are two types of Upload Journal template:
Standalone (yellow, and using the Add-ins tab)
Integrated (blue, and using the ACCESS tab)
To expand a standalone Upload Journal Template (black and yellow theme):
In Excel, open the Upload Journal Template.
Select rows 14 to 46 (the row above the black Total row), on the Home tab, in the Cells section, click Insert. The black Total row will have moved down from row 47 to row 80.
If more rows are required, continue to click Insert until the required number of rows have been added. Note: If hundreds of rows are required, after a few clicks, highlight the rows from row 14 to the row above the black Total row before continuing to click Insert.
When there are more rows than the data to be pasted in, paste in the data starting at row 13.
To expand an integrated Upload Journal Template (blue):
In Excel, on the ACCESS tab, in the Uploaders section, use the Create Sheet drop-down and select the NL Journal type required.
Select rows 13 to as many rows as are required for the data, right-click and select Insert Rows. The first click will add up to 35 rows, the second click will add up to 70 and the 3rd up to 140 rows, etc.
When there are more rows than the data to be pasted in, paste in the data starting at row 13.