Hi
serdaruzun,
What is the bit edition of Office 2010 and 2013 you are using. Is your PC a 64bit or 32bit(x86), how much RAM(memory) and Page File(Virtual Memory) set for your PC.
Here is some information that talks about 64bit Excel improvements, see if you can utilize those.
64-bit editions of Office 2013
Excel expert users who work with complex Excel worksheets can benefit from using 64-bit Office 2013.
This is because 64-bit Office doesnt impose hard limits on file size.
Instead, workbook size is limited only by available memory and system resources. On the other hand, 32-bit Office is limited to 2 gigabytes (GB) of virtual address space, shared by Excel, the workbook, and add-ins that run in the same process.
(Worksheets smaller than 2 GB on disk might still contain enough data to occupy 2 GB or more of addressable memory.)
Also as per the
earlier article from John tallks about "Word 2007/Word 2010 in compatibility mode limits".
That would mean if you have a document that is stored in the compatibility mode for previous versions (.doc etc) it will be bound by those limitations. Article says Applies to Microsoft Word 2013, hence we would consider its the supported limits, beyond
that you might have corruptions.
Just FYI, note that .DOCX is already compressed zip file.
Rename the Word
file to a Zip (.docx to .zip). Extract to find what is the actual size you are using.
Have a look at
OneNote as well.
How about you considering to convert the files to PDF for read-only purposes, incase you just want to display it to someone or so.
Architecturally there is only one limit in the PDF standard: the overall file size must be below ~10GB as the cross-reference tables which define the PDF structure use 10 bits.
Best advise would be split the data across multiple files.
Do you create really long documents in Word? If so, you probably know that Word doesnt always play well with them. Its usually smarter to split your long documents into multiple Word files.
But, then, how do you make sure the pages are numbered correctly and easily create a table of contents and an index for the whole document? Thats where
Words master document feature can help. It allows you to combine multiple Word files into a single Word file.
Create a Master Document in Word 2010 from Multiple Documents