Thread: Data connection problem excel/sharepoint using an SUMIF array
View Single Post
 
Old 10-06-2017, 12:48 AM
mwestra74 mwestra74 is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Oct 2017
Posts: 7
mwestra74 is on a distinguished road
Default
Quote:
Originally Posted by Debaser View Post
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.
Looked at it but both columns B and C have the same format in excel and my sharepoint. What I did found is that after refreshing, the array changes. The data range at the tab data changes from 10000 to 10045. Even when I changed the range to 5000, it changed to 5045.

Any idea this happens?
Reply With Quote