Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 19th 06, 10:04 PM posted to microsoft.public.excel.misc
BLopes
 
Posts: n/a
Default 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


  #2   Report Post  
Old June 20th 06, 12:15 AM posted to microsoft.public.excel.misc
Jim Cone
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: How to choose data on two separate rows in the same column RicardoE Excel Worksheet Functions 2 February 24th 06 01:41 AM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 08:05 PM
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM
How can deleted data reappear in a refreshed pivot table in Excel excel_user123456 Excel Discussion (Misc queries) 3 February 23rd 05 09:34 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM


All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017