I cannot Copy from one workbook and Paste into another...

Microsoft Office excel 2007
September 19, 2012 at 06:14:20
Specs: Windows 7
The issue I'm having is that I cannot simply copy a cell containing number values and paste them into another cell in different workbook. HOWEVER, if I select the number from the formula bar, and again paste it into the other formula bar this will work.

See More: I cannot Copy from one workbook and Paste into another...

Report •


#1
September 19, 2012 at 08:24:35
Try using Paste / Special / Values
or
Paste / Special / Formula

If you have a cell with BOTH a formula and the formula result how does Excel know which part you want pasted?

Grabbing it from the Formula bar, specifies exactly what your looking for.

MIKE

http://www.skeptic.com/


Report •

#2
September 19, 2012 at 08:33:27
Hi Mike,

Paste/ Special doesn't work because Paste isn't an option once I select the other workbook.

Just some other information, both workbooks are saved as .xlsx. I've also discovered that I can select the number from the function bar in WB A, copy it and it will let me paste the contents into a cell on WB B's without selecting the function bar, but wont let me just select the cell in WB A and paste to a cell in WB B.


Report •

#3
September 19, 2012 at 08:41:09
Do you happen to have Skype installed?

There have been some reported problems with Excel & Skype that impact the copy/paste functions:

http://www.computing.net/answers/of...

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
September 19, 2012 at 08:46:15
I do not have skype installed.

Report •

#5
September 19, 2012 at 14:05:27
You might want to run a Diagnostic:

Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics

If you don't have the Diagnostic function, try doing a Repair:

In Control Panel
Open Programs and Features
Select Microsoft Office, do not double Click on it, simply select it.
At the top of the window you should see the selection: Change
Click on Change
then select Repair.

You may need your original install media.

MIKE

http://www.skeptic.com/


Report •


Ask Question