How much data can Excel hold.
I there I'm making a big document and I would like to know the capabilities of one woorkbook because my latest is getting a bit big 45Mb and it's far from having a third of the data i want in it. Recently it stoped leting me insert sheets with more than 1Mb, but i copy and paste the data several times and it's solved. My pc has Office 2003, Windows Xp, 1Gb DDRII 533Mhz, Pentium D 2.66Ghz Dual Core. This document has macros and is password protected. After this information i would like to know: How big can a woorkbook be? What are the minimum requirements to open the biggest one? How many sheets can one workbook have? Is there any limit on hiperlinks and links? Hope to hear from you soon. -- BLopes ------------------------------------------------------------------------ BLopes's Profile: http://www.excelforum.com/member.php...o&userid=34507 View this thread: http://www.excelforum.com/showthread...hreadid=553410 |
How much data can Excel hold.
I'd say you are in danger of, one morning, having the workbook refuse to open.
You should spend some time reading and reviewing the information at Charles Williams website... http://www.decisionmodels.com/index.htm I doubt if anyone could contribute more, on the subject, than what is available there. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "BLopes" wrote in message I there I'm making a big document and I would like to know the capabilities of one woorkbook because my latest is getting a bit big 45Mb and it's far from having a third of the data i want in it. Recently it stoped leting me insert sheets with more than 1Mb, but i copy and paste the data several times and it's solved. My pc has Office 2003, Windows Xp, 1Gb DDRII 533Mhz, Pentium D 2.66Ghz Dual Core. This document has macros and is password protected. After this information i would like to know: How big can a woorkbook be? What are the minimum requirements to open the biggest one? How many sheets can one workbook have? Is there any limit on hiperlinks and links? Hope to hear from you soon. -- BLopes |
All times are GMT +1. The time now is 03:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com