+ Reply to Thread
Results 1 to 2 of 2

Can't add the rows and columns and also copy paste

  1. #1
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Can't add the rows and columns and also copy paste

    Hello Friends,

    I have a excel file which i received from client.
    First thing is that this file have 32 mb size which is too large because it has only 100 rows and 25 columns data in sheet1.
    when i want to add the rows and columns between 100 rows then it doesn't allow me, show a error which i attached here.
    i can add the row after 101th row it allow me but it will not allow to add the column anymore.
    i also clear the all cell format but problem remain same.

    I also try to copy and paste the data to new excel but it won't allow me to do that.

    Please suggest me

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Can't add the rows and columns and also copy paste

    Prob best post the file if you can, obivously be careful of sensitive data.
    That message is just an "out of memory" type error.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. [SOLVED] Help with the copy & paste of columns to rows
    By Ignesh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-28-2012, 12:57 AM
  2. Match on Rows and Columns &Copy/Paste-VBA code
    By npitts in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2012, 03:21 PM
  3. Replies: 2
    Last Post: 02-22-2011, 02:07 AM
  4. Macro to copy paste columns to specific rows
    By ohjeez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2011, 12:08 PM
  5. Changing columns to rows without copy and paste
    By BIGDAN in forum Excel General
    Replies: 2
    Last Post: 05-29-2010, 12:12 PM

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