S
Scott
I wrote a little VBA application to display data for the current row of an
Excel spreadsheet. We're using Office 2000. The users are intermittently
getting one of two errors: either system error 9 or page fault.
What I've discovered about this error:
- it only happens when the spreadsheet is shared (so no debugging
available),
- the error survives closing Excel and re-opening,
- it can't be made to happen reliably,
- once it starts it doesn't stop until the spreadsheet is saved, (this is
the workaround)
- once it starts it happens on any row of data,
- one computer may experience the error while other computers run the
application on the same data with no error,
- it occurs on Win98 and XP Pro.
Any thoughts as to how to prevent the error?
Thanks.
Excel spreadsheet. We're using Office 2000. The users are intermittently
getting one of two errors: either system error 9 or page fault.
What I've discovered about this error:
- it only happens when the spreadsheet is shared (so no debugging
available),
- the error survives closing Excel and re-opening,
- it can't be made to happen reliably,
- once it starts it doesn't stop until the spreadsheet is saved, (this is
the workaround)
- once it starts it happens on any row of data,
- one computer may experience the error while other computers run the
application on the same data with no error,
- it occurs on Win98 and XP Pro.
Any thoughts as to how to prevent the error?
Thanks.