Log in

View Full Version : Can Pivot source be in more thatn 1 file


nikeshtnt
Oct 19, 2012, 02:18 AM
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

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

nikeshtnt
Oct 19, 2012, 04:01 AM
Only if you create each pivot seperately and string them together using a movie editor.

Thanks,

Please elaborate the process for using movie editor

C0bra_M3nace
Oct 19, 2012, 04:19 AM
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.

ScottGem
Oct 19, 2012, 04:53 AM
Access also has the ability to create pivots.