+ Reply to Thread
Results 1 to 4 of 4

unable to paste data in the same work sheet in excel 2007

  1. #1
    Registered User
    Join Date
    03-23-2013
    Location
    pakistan
    MS-Off Ver
    Excel 2013
    Posts
    12

    Question unable to paste data in the same work sheet in excel 2007

    I've been using this worksheet since January 2014 and never came across such issue. Whenever the data in a row is copied (it appears to be copied shown by the dashed line around the selected data) and pasted in another row, the new row(destination) remains empty. The dashed line around selected data also disappears as iff the data is copied in normal instances.
    This sheet is linked to another excel sheet on the same PC. The other sheets on this PC are working fine. The problematic sheet holds almost 7000 rows and 30 columns of data.
    The problem stated is occuring with unlinked cells (not the linked ones).
    I've reinstalled the software and also changed the destination folder of the sheet, but all in vain.
    Any solution ?

  2. #2
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: unable to paste data in the same work sheet in excel 2007

    Can you post the workbook? Are the items being copied using absolute or relative cell references?


    If this post was helpful or at least brought a smile to your face , please click the Add Reputation button as a way to say thank you!!!!!!

  3. #3
    Registered User
    Join Date
    03-23-2013
    Location
    pakistan
    MS-Off Ver
    Excel 2013
    Posts
    12

    Re: unable to paste data in the same work sheet in excel 2007

    Sorry acroley1, I cant post the workbook. Although, the item being copied are using relative references.

  4. #4
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: unable to paste data in the same work sheet in excel 2007

    If you're using relative cell references, then when you paste data is the formula changed to look at cells that are giving you a "" result and that's why it's blank? Just a thought. I can't tell without seeing it so I'm just throwing ideas at you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Unable to Save a Excel 2007 Work Sheet containing UTF-8 Data as TEXT file
    By sundharesanr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2013, 12:34 PM
  2. Unable to copy and paste forumlas in Excel 2007
    By G2Sales&Technologies in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-06-2012, 01:38 PM
  3. Unable to open Excel sheet in Office Outlook 2007
    By Navneet in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 02-03-2012, 03:18 AM
  4. unable to enter data in Excel 2007
    By stc2011 in forum Excel General
    Replies: 14
    Last Post: 05-31-2010, 06:42 PM
  5. Excel 2007: Unable to change values by dragging data markers
    By janroger in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-10-2008, 03:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1