• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

simulating the old function of the workspace

C

Constant

New Member
Good night every one because here in Belgium it is 23:00

I have 5 excel workbooks which are exchanging data and consolidate themselves (each one is between 20 and 35 Gbytes great). There are all in the same directory.

When I open them separately (by clicking on the file in the directory) they ignore each other and they do not synchronize. I am oblige to open first excel and call them all from the first one to the last one sequentially If I do this they recognize each other and update their data automatically.

This 5 workbooks were deal from a “workspace” in earlier version of Excel (2013?). With one click on the workspace I could start all the 5 workbooks and they always recognize each other and synchronize automatically

Since excel 2016 (64 bytes) Excel do no more accept the creation of a workspace and I have the above problem. To start the bundle of my 5 excel workbook it take me 3 to 5 minutes.

My question is: Is there a way to start in one click the 5 excel workbooks and to be sure that they synchronize each other and visually organize themselves in 5 column (function arrange all). I have e 4K screen

I can’t provide an example because this are confidential data and also to big (total over 100Gbytes)

I am not good in visual basic but I eared about a start file for excel which may solve the problem.

The structure of the files are:

Workbook 1 keep trace of all financial operations on different bank accounts and their imputation on budgets and projects and third party

Workbook 2 and 2 are vert similar to the workbook 1 ane keep trace respectively of the investment accounts and the Credit cards accounts

Workbook 4 consolidate all the three first workbooks and give a year image of the wins and losts.

Workbook 1,2,3,4 are annual workbooks and copy without data every newyear (to fill in new data.

Workbook 5 summarize all the workbooks number 4 to give an image (evolution) over the years (already 20 years are booked)

The problem is annoying, because you have to stay near the computer at start and be carrefull in the following order.

I hpe some one could help me

Thanks a lot in advance.

C. Peten from Belgium
 
Constant
1) Do You really open all those workbooks in 'same time'?
2) Some of Your workbooks (depends which Your text read) are annual
... and would get new data ... every new year!
... so why to synchronize 'daily'?
3) Could some of those workbooks,
even to think to do 'minor modifications' ... to make those lighter?
 
Hi, thanks for your answer,

These files are big but do not influence the working of Excel. I have an Intel I7 processor and the 5 files are open at the same time without any problem. The recalculation takes about 15 sec and do not disturb me.

In fact Excel can handle it without any problem;

My problem is the loading of the 5 files. In excel 2016 I have no more de “workspace” definition and I must load each file separately by typing the names. Also the way to load the files is playing a role in the fact that the files synchronize or not. If I load the files by clicking on the names in the directory they do not “see” each other!! But if I start excel and then from the file function of excel if I load each file sequentially; they “see” each other and exchange data

My question is : is there a possibility to have the same functionality than the old “workspace definition” from earlier version?

Thanks in advance
 
... still, if now those files sizes are > 100Gb
then soon more and more.
sometimes size matters
- many times smaller would be useful!
> Have You tested to create macro,
which would open those one-by-one?
 
Hi Constant,
Nice to meet some-one else from Belgium here.
To me it sounds like that if you click on the files in the directory, 5 separate instances of Excel are opened (could explain why they don't "see" each other).
Since it works when you open the files on-by-one within a single Excel instance,
the advice/idea of Vletm to use a simple macro might be the thing to do.

Disturbingly enough, the behaviour of multiple instances of Excel 2010 on an win7 or Excel 2016 on a win10 seems to be very different. When you go to view and switch windows in Excel 2010 I only have those workbooks in the list I opened in the same instance. With 2016 it does not seem to matter...:confused:
I never noticed that before. Related to office version or the OS or both?
 
You must log in or register to reply here.
Back
Top