A
Amy E. Baggott
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?
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?