Have 2 workbooks approx. 4MB ea with 4 & 5 lasre worksheets. Am experiencing "cancerous" symptoms, incl 1) formats change on own, expecially which cells or rows formats are applied to. Links among worksheets shift to different rows. Message "too many formats". periodic message that workbook cannot be saved due to internal errors. Program experences "Fatal Errors".
Workbooks ALWAYS opened and closed together.
Have tried "cleaning up" by moving select worksheets. all way to copying and pasting FORMULA then FORMAT to new workbooks.
Is there any way to eliminate these types of errors?
Checkout this globally used result oriented Stellar Phoenix Excel Recovery Software.
It can effectively repairs corrupted Excel files; fix damaged Excel files having .xls, .xla and .xlsx formats. It successfully repairs excel files that got damaged due to virus attacks, sudden system shutdown, storage media corruptions, bad sectors in the disk and even accidental file deletions.
Download the free trial version to see the preview of recovered data.
You can download this software from : Stellar Phoenix Excel Recovery
It sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.
A workbook
is a spreadsheet file. By default, each workbook in Excel contains three pages
or worksheet
The term spreadsheet is often used to refer to a workbook, when in
actual fact, spreadsheet refers to the computer program, such as Excel.
So,
strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.
311 views
Usually answered in minutes!
×