Hi all,
Excel file too many data and formula. Take much time to paste the data need,
20000++ raw data in 1work sheet & another 3 work sheet around 5000++ data per each.
Have 1 work sheet is full with formula which link with other work sheet.
Please advice any way can reduct the file's heavy?
Put formula calculation as manual and then do cut and paste. Also to reduce the file size, save it as binary w.book (only in 2007+ versions, you are using 2003 but)
regards
johnjohns
When you are not sure where to go, every road takes you there!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks