I was using external database query to bring in SQL Server database. It's a very large database, and as a result, it hangs when using Pivot Tables. Is it possible to filter the data prior to coming into Excel so that I only work with a specific date frame of data?
Yes, within the query that you're running, you're able to include the WHERE clause...
SELECT [data elements]
From [tables]
Where [conditions]
However, that is not really excel related, and more SQL based.
Going for Guru! Click the Star to the bottom left of this post if I helped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks