+ Reply to Thread
Results 1 to 2 of 2

Excel 2013 continue copying in the next sheet once reached the limit of columns

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Excel 2013 continue copying in the next sheet once reached the limit of columns

    I have almost one million numbers of rows and I'd like to transpose them in columns, but since the limit of columns is way lower than that, I was wondering if it's possible to go around this problem and continue pasting in the next sheets automatically, until all the rows are transposed.

    I know that maybe it's not the best way to handle such an amount of columns, but I don't know very much about SQL and using databases, I would appreciate any advice on basic guides that cover what I need to know for this situation though.

    Thank you in advance.

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

    Re: Excel 2013 continue copying in the next sheet once reached the limit of columns

    Max number of columns in Excel 2007 (you havent said which version youre using) is 16384.
    1,000,000 / 16384 = 61.
    Thats 61 sheets, the limit on worksheets is the available system resources so it may work on one machine but not another.


    Are you sure you cannot summarize that data to produce less than a million rows?
    Do you REALLY need that level of detail?
    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. MS Excel 2013 Row Limit
    By lazz64 in forum Excel General
    Replies: 7
    Last Post: 02-03-2013, 10:25 AM
  2. Bypass Excel Rows limit and continue to copy data files to Excel
    By Mach7 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-16-2012, 07:40 AM
  3. Replies: 3
    Last Post: 04-12-2012, 01:57 PM
  4. sheet reached max limit
    By legolas in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 12-14-2011, 06:56 PM
  5. Replies: 6
    Last Post: 10-01-2010, 04:55 PM

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