<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://draft.blogger.com/navbar.g?targetBlogID\x3d25388941\x26blogName\x3dThrough+Foreign+Eyes\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttp://wildthoughtsfaq.blogspot.com/search\x26blogLocale\x3den\x26v\x3d2\x26homepageUrl\x3dhttp://wildthoughtsfaq.blogspot.com/\x26vt\x3d6141665306460740873', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>
MWave 468x60

Lakaw is a journey is a step is a move. I love to travel around the world and this is my travel and travel gadget site. Welcome and Enjoy!

0 comments | Saturday, October 20, 2007

Could I? Could I go beyond the rows and columns limit of Excel?

It is really a huge problem for me right now on how to open a file in MS Excel which has more than the limit of 65,536 rows in a single worksheet. My data also needs about 400 columns and this is beyond the 256 columns allowed in Excel.

So what is the solution for this?

Although dividing the data into separate spreadsheets is possible, yet I need to have them on a single page for some statistical analysis that I'd be doing in the future.

I looked into database alternatives, such as Microsoft Access. But I found out that Access is limited to only 100,000 rows, which is still not enough.

Puzzled for now....any help from readers will be greatly appreciated.

Labels:

0 Comments:

Links to this post:

Create a Link

<< Home

More Interesting Stories

Related Posts with Thumbnails