Hi Mahaveer,
You can try saving that file in binary format (*.xlsb) instead of xlsx. It compresses your file upto 30 to 40% and opens up it fast also.
Thanks
Sudarshan
Hi Hui,
Thanks a lot for your response.
I have tried Excel macro but with that I am able to automate only importing for some delimiter.
In Excel macro , is it also possible to automate importing all the columns in text , which we do in data import wizard?
Because for each file no of...
Hello Friends ,
I have one scenario.
Daily I paste thousands of rows in excel for analysis.
These all rows are in delimited(^) format.
So every time , I need to go to data import wizard and use delimeter(^) to import the data into excel.
When I am importing data into excel, I have one more...