M
MrIainMacleod
Hi there.
I have a spreadsheet with an unwieldy number of columns, and I'm
trying to use Custom View to make it easier to work with.
Essentially, it is a business planning assumptions' log, with columns
A-J detailing the assumption. Then, each department in the company has
a number of columns to detail the impact of the assumption on their
team, against various criteria. (i.e. Dept A has L-AN, Dept B has AP-
BR and so on)
I've created Custom Views to show A-J plus each department's columns,
and one for the whole spreadsheet.
However, when I try and create one to show just A-J, I encounter
problems. The view saves OK, but when I try and move back to it from
one of the other views, I get two error messages:
"Cannot shift objects off sheet"
Then when I click 'OK'
"Some view settings could not be applied".
Any ideas what I might be doing wrong?
Many thanks in advance.
IM
I have a spreadsheet with an unwieldy number of columns, and I'm
trying to use Custom View to make it easier to work with.
Essentially, it is a business planning assumptions' log, with columns
A-J detailing the assumption. Then, each department in the company has
a number of columns to detail the impact of the assumption on their
team, against various criteria. (i.e. Dept A has L-AN, Dept B has AP-
BR and so on)
I've created Custom Views to show A-J plus each department's columns,
and one for the whole spreadsheet.
However, when I try and create one to show just A-J, I encounter
problems. The view saves OK, but when I try and move back to it from
one of the other views, I get two error messages:
"Cannot shift objects off sheet"
Then when I click 'OK'
"Some view settings could not be applied".
Any ideas what I might be doing wrong?
Many thanks in advance.
IM