ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem with Paste function (https://www.excelbanter.com/excel-discussion-misc-queries/246094-problem-paste-function.html)

Mike O.[_2_]

Problem with Paste function
 
Hi,

I'm having problems pasting the same information more than once. For
example, I select a cell, select Copy, move to a different cell and click
Paste. The data pastes correctly but then the Paste button goes gray and
doesn't allow me to paste that same data again. I have noticed that the
worksheet says "Calculating Cells" in the bottom bar. I've tried changing
the Calculation setting under ToolsOptions to Manual but that doesn't seem
to help.

Any ideas?

Thanks in advance for your help!

Mike

Sean Timmons

Problem with Paste function
 
You're not Cutting, correct? You can only paste cut cells once per cut.

"Mike O." wrote:

Hi,

I'm having problems pasting the same information more than once. For
example, I select a cell, select Copy, move to a different cell and click
Paste. The data pastes correctly but then the Paste button goes gray and
doesn't allow me to paste that same data again. I have noticed that the
worksheet says "Calculating Cells" in the bottom bar. I've tried changing
the Calculation setting under ToolsOptions to Manual but that doesn't seem
to help.

Any ideas?

Thanks in advance for your help!

Mike


Mike O.[_2_]

Problem with Paste function
 
Correct, I'm Copying and not Cutting.

"Sean Timmons" wrote:

You're not Cutting, correct? You can only paste cut cells once per cut.

"Mike O." wrote:

Hi,

I'm having problems pasting the same information more than once. For
example, I select a cell, select Copy, move to a different cell and click
Paste. The data pastes correctly but then the Paste button goes gray and
doesn't allow me to paste that same data again. I have noticed that the
worksheet says "Calculating Cells" in the bottom bar. I've tried changing
the Calculation setting under ToolsOptions to Manual but that doesn't seem
to help.

Any ideas?

Thanks in advance for your help!

Mike



All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com