Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel: What if..?

  • 06-09-2005 3:22pm
    #1
    Steffano2002
    Registered Users, Registered Users 2 Posts: 5,918 ✭✭✭


    Hello everyone,

    What if I need more than the maximum 65536 lines Excel offers? Is the a way around this issue? :confused:

    Thank you in advance for any help you can provide! ;)


Comments

  • #2
    tba
    Registered Users, Registered Users 2 Posts: 5,111 ✭✭✭tba


    you could always use a new sheet


  • #3
    Steffano2002
    Registered Users, Registered Users 2 Posts: 5,918 ✭✭✭Steffano2002


    Of course but I have this particular report that is generated from an Access Data Base (in the one Excel s/sheet) and anything past 65536 lines is hidden... :(


  • #4
    Jerryc
    Closed Accounts Posts: 152 ✭✭Jerryc


    try www.mrexcel.com
    or www.exceltips.com

    they're both tied into Microsoft, guaranteed a response in 0 seconds


  • #5
    faustian
    Closed Accounts Posts: 12 ✭faustian


    Why don't you modify the data in Access.
    Generally you can split the data in access into smaller tables which you can then import into Excel. Otherwise if you're going to be grouping the data or wishing to run a pivot table, you can use Microsoft Query within excel to use the database as your data source rather than multiple consolidated sheets


  • #6
    Steffano2002
    Registered Users, Registered Users 2 Posts: 5,918 ✭✭✭Steffano2002


    Thanks for your help lads! As suggested by faustian, I found a workaround by using MS Query in Excel and splitting the report ;)

    Thank again! :D


  • Advertisement
Advertisement