Hello,
I have a data connection in Excel 2013 that isn't importing all of the rows that it should be returning. When I run the query in SQL management studio, it returns the part numbers I'm looking for. However, when I refresh the data in excel with the same query, it's not importing all the rows from the query and I'm missing the part numbers that I'm looking for. Anybody have any suggestions on why this is happening or how I can fix it? Thanks.
Hi andrea,
If you have defined a range of cells to be your data like $A$1:$D$200 and keep that range problems occur when you import more data. The example will only look at the first 200 rows but the second import may be 500 rows. I'd suggest you look at "Dynamic Named Ranges" for what you do your refresh on. These DNR grow and shrink to span all the data based on how many rows were imported.
http://www.ozgrid.com/Excel/DynamicRanges.htm or
https://www.vertex42.com/ExcelArticles/dynamic-named-ra nges.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi Marvin,
Thanks for the tip, I'll keep it in mind for the future. I discovered however, the answer was much simpler. My connection was to something that only updates once a day and so it took care of itself.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks