Thread: Data connection problem excel/sharepoint using an SUMIF array
View Single Post
 
Old 10-05-2017, 04:25 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
If copy and paste works, but a refresh doesn't then I am almost certain that your query is returning a number field as text.
Reply With Quote