Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Size
Hi
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? 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. I understand it can depend on other programs running at the time on your PC, what about when the file is shared? Thanks in advance. cheers Tanya |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Size
Thank you Jan for this clarification
cheers Tanya "Jan Karel Pieterse" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
WHY IS MY FILE SO BIG? How can I reduce the size of a file? I h. | Excel Discussion (Misc queries) |