:)
the summary of what i've found is, apparently a sub, probably an
auto_open sub, is trying to add page breaks via VBA & exceeding that
1026 limit. if you open the workbook in safe mode, you can hit Alt +
F11 & open the vba editor & look for an "auto_open" sub. if you find
one, highlight it, cut it, and paste it into a word document (for
temporary safekeeping). then close the document & try opening it
again (not in safe mode). if it works ok then, then it's that sub
that's causing the problem. post it here & i'll take a look @ it
tomorrow.

if it STILL won't work (outside of safe mode), then i'd open it in
safe mode & then copy & paste all the DATA to a new workbook.

if it won't open even in safe mode, well, then you'll have to try the
recovering data from a damaged workbook bit. otherwise - you've got a
lot of re-entering to do. :(
hope this all helps somewhat!
susan



On Jun 20, 4:08 pm, Susan wrote:
well, there's always

How to recover data from damaged workbooks in Excel 2002 and in Excel
2003http://support.microsoft.com/kb/820741/en-us

aha!
Excel limits the number of manual page breaks to 1026http://support.microsoft.com/kb/284916/en-us

QUOTE
With Microsoft Excel 2002, you receive the following error message:
Run-time error '1004':
This action exceeds the number of page breaks you can manually add to
a worksheet. A worksheet can contain up to 1026 horizontal page
breaks.
UNQUOTE

ummmm, but it doesn't say what to DO.
sorry! i have a little time left to keep searching, but the day (& my
internet access) is drawing to a close..........
:(
susan

On Jun 20, 4:00 pm, Susan wrote:



am searching newsgroups for ideas..............
try this:

Does it help if you switch off Tools / Options / View / Page Breaks
(do this before you try to open that file.... perhaps with just a
blank document)

do you get an error number with that message? something more concrete
i could search for? not getting anywhere with "open file page break
error"
:\
susan

On Jun 20, 1:59 pm, Dee wrote:

I am getting an error message when I try to open my excell file saying "this
action exceeds the number of page breaks you can manually add to a worksheet.
A worksheet can contain up to 1026 horizontal page breaks. This is a file
that was developed in 2004 and has been set to calculate personnel salaries
and the contract period is entered. The file is very large, but most of the
pages do not have data in them yet. I have approximately 890 lines of data
in the worksheet, but the sheet is continuous to over 6,000 lines.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -