Forum Discussion
How to split Excel file into multiple files?
Unless Olufemi7 and NikolinoDE are mind-readers, I don't see how they (or anybody) can give you a valid recommendation without knowing more about the nature of your "very large Excel workbook" with its thousands of rows. So much would depend on whether those rows are transactions that have taken place over multiple years, history that you might want to keep for reference and comparison purposes, for example, or are they thousands of different iterations of product codes that are all current. In the latter case (or comparable) you could split by categories of products; in the former, perhaps think about how much live access you need to ancient (5 years or more?) history.... and so forth.
Is the file large because many items on each row are in the form of formulas, whereas now you could convert them to values and not require recalculation each time something is done?
Lots of questions....if NikolinoDE did manage to read your mind correctly, I commend him and his solution. But if you're still seeking a workable solution, may I suggest you help us help you by giving some more descriptive details (no need to disclose confidential info) on the nature of your workbook.
I understand your point, and I agree that more details usually lead to more accurate recommendations.
In cases where the original question is not very specific and the digital environment is not clearly described, I generally assume a common setup such as Office 365 on Windows 11. I also tend to assume that the workbook structure follows a relatively standard or simplified approach unless stated otherwise.
Because of that, I usually provide an initial solution or direction that might work. Sometimes it does, sometimes it doesn’t. If the suggestion is important to the original poster and it does not solve the issue, they will normally come back with additional details so the discussion can continue in a more precise direction.
For me, the idea is simply to provide a starting point instead of asking many follow-up questions immediately. It is not meant as a definitive solution, just an initial approach that may help the user move forward.