Hello,
One of my users frequently receives different Excel spreadsheets from different partners and needs to aggregate numbers from those many spreadsheets (all in different formats) into a "master" spreadsheet. They would work by having side-by-side Excel windows: one with the input spreadsheet and one with the master spreadsheet and go as follows:
1. select the cells to be aggregated on the input spreadsheet
2. read the status bar aggregates (sum, average) and report them on the master spreadsheet
(each input spreadsheet may contains dozens of aggregates to be reported).
We recently migrated from Vista + Excel 2007 to Win 8.1 + Excel 2013, and a minor change is affecting this task dramatically: when 2 Excel 2013 windows are opened side-by-side, focusing on one of them will "hide" the status bar aggregate from the other window, which makes this task now much more cumbersome since it is no longer possible to read the status bar agg values from the first spreadsheet while entering data in the second spreadsheet.
Here are a few screenshots to explain what's happening:
1. select numbers from the input -- the aggregate show up in the status bar
2. focus on another program (e.g. notepad) -- the aggregate still show up
3. focus on another Excel 2013 window -- the aggregate are hidden from the first Excel window
This may not seem like much, but it's really making our life harder (the numbers we're talking about are quite large sometimes, making the select/read/remember/type action a lot more annoying than select/type-as-you-read).
I would appreciate anyone's help with this.
Kind regards,
One of my users frequently receives different Excel spreadsheets from different partners and needs to aggregate numbers from those many spreadsheets (all in different formats) into a "master" spreadsheet. They would work by having side-by-side Excel windows: one with the input spreadsheet and one with the master spreadsheet and go as follows:
1. select the cells to be aggregated on the input spreadsheet
2. read the status bar aggregates (sum, average) and report them on the master spreadsheet
(each input spreadsheet may contains dozens of aggregates to be reported).
We recently migrated from Vista + Excel 2007 to Win 8.1 + Excel 2013, and a minor change is affecting this task dramatically: when 2 Excel 2013 windows are opened side-by-side, focusing on one of them will "hide" the status bar aggregate from the other window, which makes this task now much more cumbersome since it is no longer possible to read the status bar agg values from the first spreadsheet while entering data in the second spreadsheet.
Here are a few screenshots to explain what's happening:
1. select numbers from the input -- the aggregate show up in the status bar
2. focus on another program (e.g. notepad) -- the aggregate still show up
3. focus on another Excel 2013 window -- the aggregate are hidden from the first Excel window
This may not seem like much, but it's really making our life harder (the numbers we're talking about are quite large sometimes, making the select/read/remember/type action a lot more annoying than select/type-as-you-read).
I would appreciate anyone's help with this.
Kind regards,
