Excel 2010 Problem

You will guess from this post I am a computer novice so I hope this will be easy for you experts to solve for me.
I am using excel 2010 I have cut and pasted a couple of rows of information from one spread set to another and now inadvertantly have done some thing which has completely locked me out from adding more information on the spread sheet I pasted to.A Micrsoft message window keeps popping up saying Reference is not valid.Where did I go wrong and more importantly how do get rid of it so I can continue with a spread sheet that has taken me ages at tortise pace .Many Thanks

geek_soundie1, Apr 3, 9:55 am


It sounds like some of the 'information' you cut and pasted included cells with formulae that now can't 'see' the cells containing the information they need to make the calculation. Either that or the rows you tried to cut and paste were from a 'pivot table' all of which depends on data it now can't find.

There is no easy fix without looking at the spreadsheet I'm afraid

geek_cafc2012, Apr 3, 10:02 am

In this case when you did the paste, you should have chosen a 'Paste Special' and pasted Values - not formulas.

geek_gyrogearloose, Apr 3, 10:08 am

Always good in hindsight.

geek_ceebee2, Mar 29, 11:16 am

Share this thread