Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Can Pivot source be in more thatn 1 file (https://www.askmehelpdesk.com/showthread.php?t=710152)

  • Oct 19, 2012, 02:18 AM
    nikeshtnt
    Can Pivot source be in more thatn 1 file
    Hi,

    I have an excel file of 135 MB for data of the year. I can break this as per monthly data but need to draw the singal pivot.

    Is it posible that I can creat a Pivot using more than 1 files.

    Regards,

    Nikesh
  • Oct 19, 2012, 03:54 AM
    C0bra_M3nace
    Only if you create each pivot separately and string them together using a movie editor.
  • Oct 19, 2012, 04:01 AM
    nikeshtnt
    Quote:

    Originally Posted by C0bra_M3nace View Post
    Only if you create each pivot seperately and string them together using a movie editor.

    Thanks,

    Please elaborate the process for using movie editor
  • Oct 19, 2012, 04:19 AM
    C0bra_M3nace
    If you're not farmiliar with using a movie editor such as "Windows Movie Maker" then the process of stringing them together can be nearly impossible without taking the time to learn.

    It would be just as impossible for me to walk you through the process on a forum, as there are many different steps to it.

    Your best bet is to start playing around with different movie editors and learn on your own, or find some simple tutorials online on the editor you end up using.
  • Oct 19, 2012, 04:53 AM
    ScottGem
    Access also has the ability to create pivots.

  • All times are GMT -7. The time now is 08:58 AM.