Guys,
How will I lessen the size of excel file?
Here is my task:
I am working on this project (monthly record analyzer) consisting of daily records (each record is one excel file). Each record contains two columns, 1st is the time and 2nd is the value at that particular time. The number of rows reaches 86,000 or 87,000. How will I compile the 1 month excel files in one file in the best way to minimize its size. Please help me on this.
Which is better? 1. Copy all the records in one sheet then the summary is on another sheet; or 2. Separate the daily records for every sheet including the summary.
How will I lessen the size of excel file?
Here is my task:
I am working on this project (monthly record analyzer) consisting of daily records (each record is one excel file). Each record contains two columns, 1st is the time and 2nd is the value at that particular time. The number of rows reaches 86,000 or 87,000. How will I compile the 1 month excel files in one file in the best way to minimize its size. Please help me on this.
Which is better? 1. Copy all the records in one sheet then the summary is on another sheet; or 2. Separate the daily records for every sheet including the summary.