S
SueDot
I am using Excel 2003 - SP2 on a company network. I have installed the
Analysis Toolpak and Analysis Toolpak - VBA addins.
I have three workbooks that are linked with formulas, and opened as a
Workspace. This set is re-saved ad nauseum, for the multiple number of
clients for which we maintain cost reports. They are ancient reports that
have been fixed and tweaked numerous times, so the creation of them belongs
to about 5 or 6 people over the years. At this point, it's not frugal to
remake the workbooks from scratch to eliminate the two problems that are
occurring, so I'm hoping someone might know what these are and/or how to fix
them.
First issue: Often, when opening the Workspace, I get an error message as a
certain one of the three workbooks is trying to open. The message says: "The
number must be between 10 and 400. Try again by entering a number in this
range." I think the title in the bar at the top of the error message says
"Cell Edit", or something of that nature. Is there a way to identify WHERE
this mysterious cell edit exists? I was part of the two-person team who last
overhauled these workbooks, so I know that WE didn't put in any cell edits,
so it must be a leftover thing that's now hidden from view from a previous
"overhauler".
Second issue: When opening the Workspace, there is one worksheet in one
workbook that always defaults or reverts to a zoom view of 0%. Sometimes
when it opens, it will be at 100%, but as soon as I select the workbook
containing that sheet, it automatically reverts to 0% and everything goes
grey. This only happens that one time (every time), during the opening of
the Workspace. It's very easy to fix this glitch, but it's ULTRA annoying
when I'm opening and closing dozens of reports every day and constantly
having to fix this. It also panics the people who only occasionally open the
reports - they think the data has mysteriously evaporated and they go into
meltdown mode. Is there a good, fixable reason why this glitch happens?
Analysis Toolpak and Analysis Toolpak - VBA addins.
I have three workbooks that are linked with formulas, and opened as a
Workspace. This set is re-saved ad nauseum, for the multiple number of
clients for which we maintain cost reports. They are ancient reports that
have been fixed and tweaked numerous times, so the creation of them belongs
to about 5 or 6 people over the years. At this point, it's not frugal to
remake the workbooks from scratch to eliminate the two problems that are
occurring, so I'm hoping someone might know what these are and/or how to fix
them.
First issue: Often, when opening the Workspace, I get an error message as a
certain one of the three workbooks is trying to open. The message says: "The
number must be between 10 and 400. Try again by entering a number in this
range." I think the title in the bar at the top of the error message says
"Cell Edit", or something of that nature. Is there a way to identify WHERE
this mysterious cell edit exists? I was part of the two-person team who last
overhauled these workbooks, so I know that WE didn't put in any cell edits,
so it must be a leftover thing that's now hidden from view from a previous
"overhauler".
Second issue: When opening the Workspace, there is one worksheet in one
workbook that always defaults or reverts to a zoom view of 0%. Sometimes
when it opens, it will be at 100%, but as soon as I select the workbook
containing that sheet, it automatically reverts to 0% and everything goes
grey. This only happens that one time (every time), during the opening of
the Workspace. It's very easy to fix this glitch, but it's ULTRA annoying
when I'm opening and closing dozens of reports every day and constantly
having to fix this. It also panics the people who only occasionally open the
reports - they think the data has mysteriously evaporated and they go into
meltdown mode. Is there a good, fixable reason why this glitch happens?