QueryTable Becomes Values after Refresh

D

donbexcel

In Excel 2003 I have several sheets with QueryTables that become values
after they are refreshed, meaning they can no longer be refreshed. If I look
at the defined names for the sheet the refers to value looks like this
"= Dataquery!$A$1:$Q$22456" it has spaces after the equals sign. The sheet
name does not contain spaces.

Is there a cure for this?

Regards,

Don Buchanan
 
Top