M
Mary Ellis
I am using Excel 2007 working in a workbook that has forms for each census
year. In the form I put the data for the family name that I am researching,
these forms might be several hundred lines to several thousand lines each.
Size of each census year may vary. There is quite a bit of formatting, with
merged cells, rotated text, etc.
Almost every time the sheet crashes the rotated text will go back to
normal.. That is a pain, to have to reformat all that.
Point being, the file itself can get rather large.
Although I don't think that the size of the file has as much to do with the
crashes as the formatting does.
I have had it crash many times since starting this particular workbook.
Usually somewhere it will say something about the amount of formatting done
on the sheet.
Surely having a large file with formatting should not cause the amount of
crashes I get.
Does anyone have any suggestions as how to stop this from happening.
year. In the form I put the data for the family name that I am researching,
these forms might be several hundred lines to several thousand lines each.
Size of each census year may vary. There is quite a bit of formatting, with
merged cells, rotated text, etc.
Almost every time the sheet crashes the rotated text will go back to
normal.. That is a pain, to have to reformat all that.
Point being, the file itself can get rather large.
Although I don't think that the size of the file has as much to do with the
crashes as the formatting does.
I have had it crash many times since starting this particular workbook.
Usually somewhere it will say something about the amount of formatting done
on the sheet.
Surely having a large file with formatting should not cause the amount of
crashes I get.
Does anyone have any suggestions as how to stop this from happening.