Excel Error Message

C

Cherly

Hi~
I am using Windows 98. I have a spreadsheet that contains
macros - which are from a safe source. The spreadsheet
has a total of 8 worksheets. The first two worksheets
have data, the remaining worksheets have charts which are
based off of the second worksheet. The first tab is
called "Input 2" and the second is called "Total $s and
Per Hr 04". The data in the "Input 2" worksheet is from
Access - and the "Total $s and Per Hr 04" sheet is the
same data in a more appealing format. When I try and have
a cell in the Total $s tab reference another cell in the
Input 2 tab I get an error message stating that "This
program has performed an Illegal operation and will shut
down." The description is the following: Excel caused an
invalid fault in module MS097.DLL at 0167:3070ab13.
It then gives a list of registers.
Any ideas? I made a copy of the spreadsheet and the same
thing happens on the copy as well as the template. Thanks
Cherly
 
D

Dave Peterson

Just a wild guess.

if you recreate part of the data in a brand new workbook, does excel blow up?

If no, you may want to recreate all the data and toss that original workbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top