External table is not in the expected format.
I have an Excel 2007 Workbook that connects to another Excel 2007 Workbook to
take raw data and turn it into a Sales Report. When it is run on any
computer in the office but mine, it works fine. When I run it and click
"Refresh All," I get the message "External table is not in the expected
format." unless I have the raw data worksheet open when I refresh. As far as
I know, all our computers are set up the same way, so I don't understand why
it would work fine with everyone else's computer and not with mine. Any
ideas?
--
Amy E. Baggott
"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
|