How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

We have a problem in Excel on just one machine - all the others

Customer Question

We have a problem in Excel on just one machine - all the others work correctly. The problem arises when trying to copy and paste/special paste from one workbook to another. Copying within the same workbook is no problem, it works. The problem is only encountered when attempting to do this into another workbook. We can also not copy a tab into another workbook
Submitted: 3 years ago.
Category: Microsoft Office
Expert:  businesslegions replied 3 years ago.

businesslegions :

Hi there,

businesslegions :

My name is Marco and I'll be assisting you with this issue.

businesslegions :

PLEASE NOTE: If this chage here and I'll connect as soon as I can.

businesslegions :

Do you know when this problem occurred or did you always have this problem?

businesslegions :

hi

JACUSTOMER-veuoekcb- :

it is a new installation and has been like this since the begining

businesslegions :

have you tried uninstalling an reinstalling?

JACUSTOMER-veuoekcb- :

yes we did

businesslegions :

does this computer have any other applications

businesslegions :

installed compared to the others?

JACUSTOMER-veuoekcb- :

no

businesslegions :

which version of office are you using?

JACUSTOMER-veuoekcb- :

2010 proffesional plus

businesslegions :

ok let me check

businesslegions :

it could be an addin in excel

businesslegions :

that could be stopping it

JACUSTOMER-veuoekcb- :

Full Size Image

businesslegions :

Can you go to tools

businesslegions :

then addins

businesslegions :

and are there any checked addins?

JACUSTOMER-veuoekcb- :

there are no add ins

businesslegions :

so nothing is ticked?

JACUSTOMER-veuoekcb- :

that is what excel gives me

businesslegions :

the items that youve selected from the other workbook

businesslegions :

is it just 1 cell?

businesslegions :

sorry can you try copying and pasting once cell

businesslegions :

rather than a block

JACUSTOMER-veuoekcb- :

i have tried that read it in a forum.

businesslegions :

that didn't work?

JACUSTOMER-veuoekcb- :

Full Size Image

businesslegions :

can you check your cliboard

JACUSTOMER-veuoekcb- :

that is a sceenshot of paste special on the same workbook but i want to pate it like that on another woorkbook one that i opened sepperatly

businesslegions :

click on the dialog box launcher button in the lower right corner of the clipboard group on the ribbon tab

JACUSTOMER-veuoekcb- :

have opened it

businesslegions :

do you see the contents of the other workbook

JACUSTOMER-veuoekcb- :

i have opend my clipboard

businesslegions :

do you see the contents from the other workbook?

JACUSTOMER-veuoekcb- :

yes

businesslegions :

can you click on the arrow and select paste?

JACUSTOMER-veuoekcb- :

will do that just hold,

JACUSTOMER-veuoekcb- :

it works but i want it to paste the data with the formulas

businesslegions :

ok

businesslegions :

are there any special formulas being used?

JACUSTOMER-veuoekcb- :

VLOOKUP and IF

businesslegions :

the might be a problem with the vlookups

businesslegions :

because they are referencing worksheets within the workbook

businesslegions :

but you said it works on other computer?

JACUSTOMER-veuoekcb- :

but the formulas work on the same woorkbook

businesslegions :

are they referencing different worksheets?

JACUSTOMER-veuoekcb- :

yes

businesslegions :

but you mentioned it works on other machines

businesslegions :

so that must not be the problem...

JACUSTOMER-veuoekcb- :

whenever i try to paste special on another workbook it does not give me the options such as "paste values" and "other paste options" when i put the curser op paste special

businesslegions :

are the other machines you've tested, are they also lenovo laptops?

JACUSTOMER-veuoekcb- :

no its desktops and the others are acer

businesslegions :

and they don't have the problem?

JACUSTOMER-veuoekcb- :

no

businesslegions :

ok restart the laptop

businesslegions :

and press F8 and go into safe mode

JACUSTOMER-veuoekcb- :

and then

businesslegions :

test it

businesslegions :

to see if you get the options

JACUSTOMER-veuoekcb- :

test what

JACUSTOMER-veuoekcb- :

ok ima do it for you

businesslegions :

the paste values options

businesslegions :

let me know when you're on

Related Microsoft Office Questions