J
John C
I will endevour to explain two concerns with a report I am creating.
Additionally the files are stored in 2003 format.
The file contains worksheets with either a monthly report, data, information
or comments. The formulas are not complicated and the report just draws text
from the information (objects set), the data is updated and feeds into a
chart on the report against each objective and the comments are basic
statements to say how an objective is progressing.
Issue #1
After the file was created everything was functioning correctly. Charts were
updating as the data was changed etc. After the file had been saved and
copied to set new objectives for a new subject, when it was reopened most of
the graphs had moved from their original positions. They were on top of each
other and some on the wrong worksheets. After repositioning the same thing
happened the next time a copy was made.
Issue #2
The report takes text from the comment sheet and inserts it next to the
appropriate chart. This is using the normal "=" plus the cell location and
name of the comment sheet. Now some of these cells are not showing the text
from the comment sheet but only the location of the target cell i.e. instead
of showing the text at location "=sheet2!cell3" it will only display that
location =sheet2!cell3 as the text. I can select a different cell on the
worksheet and get the function to operate correctly, there is no difference
in the format of the cells compared to any that function, if the target cell
information is deleted and reentered the same condition is present. If there
is a cell that is functioning correctly, if I move it to the location I want
on the report it will then operate corrrectly.
I appreciate any comments
Thanks
Additionally the files are stored in 2003 format.
The file contains worksheets with either a monthly report, data, information
or comments. The formulas are not complicated and the report just draws text
from the information (objects set), the data is updated and feeds into a
chart on the report against each objective and the comments are basic
statements to say how an objective is progressing.
Issue #1
After the file was created everything was functioning correctly. Charts were
updating as the data was changed etc. After the file had been saved and
copied to set new objectives for a new subject, when it was reopened most of
the graphs had moved from their original positions. They were on top of each
other and some on the wrong worksheets. After repositioning the same thing
happened the next time a copy was made.
Issue #2
The report takes text from the comment sheet and inserts it next to the
appropriate chart. This is using the normal "=" plus the cell location and
name of the comment sheet. Now some of these cells are not showing the text
from the comment sheet but only the location of the target cell i.e. instead
of showing the text at location "=sheet2!cell3" it will only display that
location =sheet2!cell3 as the text. I can select a different cell on the
worksheet and get the function to operate correctly, there is no difference
in the format of the cells compared to any that function, if the target cell
information is deleted and reentered the same condition is present. If there
is a cell that is functioning correctly, if I move it to the location I want
on the report it will then operate corrrectly.
I appreciate any comments
Thanks