Data connection problem excel/sharepoint using an SUMIF array

Debaser · #1 10-05-2017, 04:25 AM

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.

mwestra74 · #2 10-06-2017, 12:48 AM

Quote:

Originally Posted by Debaser

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I make a checkbox or dropdown item reference data in that specific section of the data array?	dhare	Excel Programming	2	02-24-2016 12:36 PM
Data connection from Excel to Sharepoint not working	GraemeW	Excel	0	01-16-2016 04:31 PM
MS Excel - SQL Data Query Connection to MS Project - Resource Displayed in Multiple lines not in one	AKent	Excel	3	08-26-2015 01:34 PM
Excel 2007 security alert - data connection message every time?	michael.monaco	Excel	0	12-20-2012 07:47 AM
How to count the frequency of data and also tally value from an array of Excel record	KIM SOLIS	Excel	5	09-07-2011 09:01 AM