What caused my paste function not to work?

E

EXCEL USER

Even I checked the box under tools/edit/show paste button, I can not copy and
paste from one excel workbook or file to another.

How can I make the paste function work again? When I am in a work book, or
click on Edit, the "paste" option is not highlighted on the toolbar.
 
M

Matt Geare

Sounds like a worksheet protection issue - check that the worksheet where the
paste button is disabled is not protected.
 
P

PhilUK

EXCEL said:
Even I checked the box under tools/edit/show paste button, I can no
copy and
paste from one excel workbook or file to another.

How can I make the paste function work again? When I am in a work book
or
click on Edit, the "paste" option is not highlighted on the toolbar.
Click to expand...

Do you have Charles Williams FasteExcel addin installed?
Are you using the Active Workbook mode in the Calculation Options an
settings?

While this is active you cannot copy and paste between workbooks

I found this out from personal experience! It is mentioned in the hel
file but "blokes" don't read intructions do we
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste options button disappears 0
Visio shape text disappears upon copy paste 1
Bugs in Office 2019 0
Word isn't capitalizing the first word of each sentence 2
Pasting Data from One Workbook to Another 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Excel not pasting the formula or reference 1

Top