COPY WORKSHEET REFERENCING ISSUES

  • Thread starter Thread starter chondria69
  • Start date Start date
C

chondria69

I have been seething and searching in 'super' frustration at MS
recently. I need to copy worksheets (within a workbook) with numerous
equations and charts, all referenced within the sheet itself, and to
no other sheet.

When I use by bro's Office 2003 SP2 Excel, the copied sheet references
itself = perfect! Now I can modified the data within the cells of the
new worksheet, making new updated charts. life's good.

When I use Office 2007 on my desktop, all of the graphs in the newly
copied worksheet, reference the original worksheet. Now the chart has
to be selected, and every item within that chart has to be updated to
reference the present worksheet. Too much work, and not going to
happen.

When I use my dell laptop with Office 2007, the cells are copied
perfectly, like my bro's office 2003. I cannot find a setting or any
info that defines the 'copy' parameters. And when I MACRO the 'copy'
on all three computers, the macro is exactly the same.

Why would MS make this blunder? Are they completely stupid, the way I
tend to feel about them most of the time, Or is it me and I am I
really missing something.

Any help would be 'super' greatly appreciated.
 
How are you copying the worksheets? Are you right clicking on the worksheet
name tab and select move or copy? This method results in a warning about cell
references when you change to the worksheet after copying it but I have found
that I can just click OK and ignore it and all the references are correct.

I know that you cannot simply select all the cells (including the charts) on
the worksheet and copy and paste because the charts retain the original cell
references.

I am interested in how you go with this because the warning message about
cell references always worries me but so far I have not been able to find any
real errors.
 
How are you copying the worksheets? Are you right clicking on the worksheet
name tab and select move or copy?
Click to expand...

YES, I'm right clicking on the worksheet, and selecting COPY.
This method results in a warning about cell
references when you change to the worksheet after copying it but I have found
that I can just click OK and ignore it and all the references are correct.
Click to expand...

I have never seen that warning. Neither in Office 2003 or 2007.
I know that you cannot simply select all the cells (including the charts) on
the worksheet and copy and paste because the charts retain the original cell
references.
Click to expand...

Of course.
I am interested in how you go with this because the warning message about
cell references always worries me but so far I have not been able to find any
real errors.
Click to expand...

I recorded/made MACROS on four different computers, with different
mixes of XP/Vista & Office 2003/2007. After making them, I reviewed
the code, and they were identical in coding, yet they do different
things. See below:

XP/2003 = Copy Sheet works perfectly; new sheet references itself.
XP/2007 = Copy Sheet sucks; new sheet references old sheet = trash.
Vista/2007 = Copy Sheet works perfectly; new sheet references itself.
Vista/2007 lptp = Copy Sheet sucks; new sheet references old sheet =
trash.

I am at a loss as to why this occurs. A particular macros will do
different things on different machines, even though it is the same
code. Wierd.
 
Hi Chris,

I see what you mean. I am using Office 2007 with Vista Home and 202 with XP.
Just for interest, are the 2 computers that you used for testing with Vista
loaded with the same Vista?
 
Hi Chris,

I see what you mean. I am using Office 2007 with Vista Home and 202 with XP.
Just for interest, are the 2 computers that you used for testing with Vista
loaded with the same Vista?
Click to expand...
Both have Vista Ultimate. One has SP1 pre RC1 beta, the other has the
latest SP1 RC1 beta (released a couple of days ago). THe XP machine
with O2007, is SP2.
 
Back
Top