Thread: File Size
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default File Size

Hi Tanya,

I am concerned about the size of my Excel Workbook [43 MB] could anyone tell
me if there is any immediate concern with a file this size? i.e. data
integrity or crashing?


As such this isn't too big a file for Excel to handle. It will be slow in
loading and saving, but it should work.

I intend to share the file across a network and the computers accessing the
file will be modern computers with roughly 2GHz Processor, 1 GHz Ram; running
WINXPS2.


Now THAT is a concern. Sharing Excel files is a dangerous thing to do as Excel
isn't up to the task. Many people report problems with shared files, like
corruption of the file, loss of data, changes not being saved or being saved
wrongfully.

If you need multiple users editing information at the same time, do not use
Excel. Use a database application instead. Like Access or SQL Server.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com