Re: $$Excel-Macros$$ Query to retreive data

2015-04-28 Thread Mandeep Baluja
Excel 2010 and file is on the same machine. Vabz I know the procedure to get the data from excel file but here my file is always large and opening will take a lot of time . On Tuesday, April 28, 2015 at 11:59:45 AM UTC+5:30, Vabz wrote: Which version of excel you are using? Are both file

$$Excel-Macros$$ Query to retreive data

2015-04-28 Thread Mandeep Baluja
My mmaster file is large and i just want to do lookup on my sheet from master file without opening my master file as it is of huge mb around 250 mb or more than that. any ideas -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

Re: $$Excel-Macros$$ Query to retreive data

2015-04-28 Thread Vaibhav Joshi
Which version of excel you are using? Are both file on same machine or they are on Network? On Tue, Apr 28, 2015 at 11:34 AM, Mandeep Baluja rockerna...@gmail.com wrote: My mmaster file is large and i just want to do lookup on my sheet from master file without opening my master file as it is