View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amy E. Baggott Amy E. Baggott is offline
external usenet poster
 
Posts: 1
Default 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