Connecting data in multiple Excel Files Vs. Connecting data in multiple sheets in the same file

%3CLINGO-SUB%20id%3D%22lingo-sub-1307420%22%20slang%3D%22en-US%22%3EConnecting%20data%20in%20multiple%20Excel%20Files%20Vs.%20Connecting%20data%20in%20multiple%20sheets%20in%20the%20same%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1307420%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20one%20excel%20file%20with%20many%20tabs%2C%20and%20all%20of%20them%20are%20related%20to%20each%20other%20with%20many%20equations.%3C%2FP%3E%3CP%3EThe%20file%20got%20very%20slow%20and%20hang%20a%20lot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20recommend%20to%20take%20the%20data%20from%20the%20different%20sheets%20to%20other%20files%20and%20then%20connect%20these%20files%20together.%20Will%20this%20make%20it%20faster%20and%20more%20efficient%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1307420%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1307492%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20data%20in%20multiple%20Excel%20Files%20Vs.%20Connecting%20data%20in%20multiple%20sheets%20in%20the%20same%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1307492%22%20slang%3D%22en-US%22%3EHello%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20all%20the%20sheet%20tabs%20in%20your%20Excel%20workbook%20are%20related%20and%20they%20have%20the%20same%20structure%2C%20the%20best%20practice%20is%20to%20combine%20all%20the%20sheet%20tabs%20together%20into%20a%20single%20sheet..%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20example%2C%20you%20have%20Jan%20to%20Dec%20sheets%20that%20contains%20sales%20records.%20All%20you%20need%20to%20do%20is%20combine%20all%20the%20Jan%20to%20Dec%20data%20into%20a%20single%20sheet%20and%20create%20another%20column%20in%20the%20single%20summary%20sheet%20where%20you%20will%20have%20all%20the%20months%20of%20Jan%20to%20Dec%20bases%20on%20the%20corresponding%20data%20for%20each%20month.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have one excel file with many tabs, and all of them are related to each other with many equations.

The file got very slow and hang a lot.

 

Do you recommend to take the data from the different sheets to other files and then connect these files together. Will this make it faster and more efficient?

1 Reply
Highlighted
Hello,

If all the sheet tabs in your Excel workbook are related and they have the same structure, the best practice is to combine all the sheet tabs together into a single sheet..

For example, you have Jan to Dec sheets that contains sales records. All you need to do is combine all the Jan to Dec data into a single sheet and create another column in the single summary sheet where you will have all the months of Jan to Dec bases on the corresponding data for each month.