Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Pivoting extending the filter

Posted on 2014-03-12
Last Modified: 2014-03-12
Hi all

I have PowerPivot built with excel
That retrieves values from a CSV file
Now since we are now in 2014. new data
from 2014 could not be displayed.
How can I modify the PowerPivot to display these data?
Thanks in Advance

Question by:ZURINET
  • 2
  • 2
LVL 29

Accepted Solution

gowflow earned 500 total points
ID: 39923309
Could you post the workbook ?

Do you need a manual solution or thru VBA ?


Author Comment

ID: 39923436
Hi Gowflow..

Just solved it..
The workbook source file is in the wrong directory..


Author Closing Comment

ID: 39923463
No.. solution .. but point awarded because of interest
LVL 29

Expert Comment

ID: 39923485
Well thanks but would hv preferred to provide a contribution somehow.

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Logon script fails 23 45
Can't get rid of Update Links message in Excel 2013 8 28
Excel 2013 Issues 11 41
Batch Numbering 6 29
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question