Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Possible to split one BIG excel file in MANY separate ones?

09 Feb 2017   #1
WimYogya

windows 7
 
 
Possible to split one BIG excel file in MANY separate ones?

Hello,

I am looking for a way to split my BIG excel file (2000 rows x 60 columns) into a number of smaller ones.
But... in such a way that the forumulas of each file are still 'related', so if i modify one cell, the results should be changed in all the 'related' cells in all other files/workbooks.

The purpose is the following:
The big excel sheet is my upcoming travel calendar, for a 12 week trip. It is both an itinerary schedule (including sights, prices, opening hours, links) and two calculators:
1. the budget PLANNER: how much do we expect to spend each day and how much is the expected sub-total budget up to a particular day.
2. the expense TRACKER: how much do we actually spend on each day, and at the end of a particular day, can we compare the balance with the one in the budget planner (1), to see if we spend as expected or less or more.

All this works fine (for me at least...) in my pc where I created the tool.
But of course I will not bring my pc all over Europe...
I would prefer to make a 'dynamic copy' on my tablet, i.e. not just the static values as they are NOW, more or less as a picture of all - but with the active formulas.
But for sure my tablet has not enough memory, speed, calculation capacity, storage capacity to handle such big file.

Can i then split it in 12 'weekly' excel sheets?
Or even in 84 'day sheets'?

And then open them one by one on the particular days, make necessary changes and save them?
In such a way that the modifications on a particular day affect the results on the other days?

No idea at all!

Or, would there be a way to upload my WHOLE sheet to my own Google Drive, and open that whenever I have access to a pc somewhere in a hotel or at a friend's place???

Curious to read your suggestions and solutions,
Thanks in advance!

Wim


My System SpecsSystem Spec
.
09 Feb 2017   #2
RolandJS

Windows 7 Professional 64-bit
 
 

I'm not certain if the following free version/online version will help at all:
Excel Converter That Supports All Types Of Spreadsheets
I have never split a spreadsheet into parts, not even the ones make by Quattro Pro/DOS.
My System SpecsSystem Spec
10 Feb 2017   #3
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

Please help me understand - what is "big" about this file? 2000 rows x 60 columns is hardly what I consider as "big".
What are the issues you have with this modestly sized spreadsheet? Yes, I read your post but I can't see why/what the problem is.

Regards,
GEWB
My System SpecsSystem Spec
.

11 Feb 2017   #4
WimYogya

windows 7
 
 

@RolandJS
Thanks for the suggestion, but it does not give the split-function that I looked for.
At the moment I am working on a sort of workaround, with a static copy of my sheet that I then can make more compact and dynamic again (byy adding some new formulas). Thanks.
@GEWB
One of the reasons for slow performance (if I make a full copy in my tablet) is the conditional formatting, apparently. I plan to switch it off (in the tablet only) to see if that speeds things up.
My tablet is already quite full, both in space and in memory. I want to bring many useful apps, data, music, video when I am away from home for 3 months...

For the time being I try to focus on these and other improvements and the workaround with the resume.
If anyone anytime still finds a 'split option', please inform. Thanks!
My System SpecsSystem Spec
Reply

 Possible to split one BIG excel file in MANY separate ones?




Thread Tools




Similar help and support threads
Thread Forum
Split a txt file \n ?
want to split a txt file.First i open the txt file with notepad++ and i change from this \r\n to this \n , then i want to split them in 1o pieces and for that i use a tool called split or joinand also this script and when i check them i see are \r\n\ again.How to split a txt file \n and keep...
General Discussion
How do I open multiple Excel 2007 files in separate windows?
Hey, I want to open multiple Excel 2007 files in separate windows because I have 2 separate monitors. This works with for example Word (just double click on two different word files) but not with Excel. I read some work-around saying "open the first excel file by double clicking, then open an...
Microsoft Office
How to split 1 mp3 file to 2?
I have an mp3 file that, although it says 1 file, is comprised of 2 individual meditation tapes. These individuals are separate (FLAC) files on the CD's shipped but for whatever reason they're combined on the download into 1 mp3. Although I can copy a FLAC file to the drive and convert it to...
Music, Pictures & Video
How-to Split STR From Movies MKV File ?
I Need to Watch In Splash Pro EX But.. Problems With Subtitle. It Not Show. Now I Can Select Sound Only http://img85.imageshack.us/img85/4606/46397977.png
General Discussion
Split IE Browser in two separate fully independent windows
Internet Explorer Browser plug-in. Split IE in two separate fully independent windows have been using maxthon browser with this feature and found this little gem of a toolbar add-on for IE fully working in my IE browser as in the pic. links>> Home ...
Browsers & Mail


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 04:03.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App