This question is related to something so simple that there was never a video or anything posted about it. heres the problem.
I am using Excel 2010, with the powerpivot add-in and everything is up to date and state of the art.
I have 20 excel worksheets that i would like to basically connect as one large 20 million row spreadsheet.
Thats it.
ive tried everything that i could imagine and nothing is working.
As it stands i have to update each file separately on a daily basis and each file takes about 5 minutes to open and 5 minutes to save costing me about 200 minutes a day (3 hours 20 minutes) of sitting around.
i want to be able to do one update, on one file.
Boom! easy right? then how come i cant find it??
please help me i think ive covered everything.
all i keep hearing is "oh wow powerpivot is the greatest and some can hold up to 150 million rows of data!!"
yeah?? how??
please please help.
thanks in advance- anthony.
I am using Excel 2010, with the powerpivot add-in and everything is up to date and state of the art.
I have 20 excel worksheets that i would like to basically connect as one large 20 million row spreadsheet.
Thats it.
ive tried everything that i could imagine and nothing is working.
As it stands i have to update each file separately on a daily basis and each file takes about 5 minutes to open and 5 minutes to save costing me about 200 minutes a day (3 hours 20 minutes) of sitting around.
i want to be able to do one update, on one file.
Boom! easy right? then how come i cant find it??
please help me i think ive covered everything.
all i keep hearing is "oh wow powerpivot is the greatest and some can hold up to 150 million rows of data!!"
yeah?? how??
please please help.
thanks in advance- anthony.