Workbook copy problem

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

strange problem occurring when using a workbook at work, hope someone can
help please.

everyweek workbook is copied and renamed to include current weeks date and
previous weeks figures are cleared etc, this is so each week has a record
saved.

I updated the workbook at home, added a new sheet, this sheet grabs figures
from about 16 others and totals them up.

the problem occurs after copying the workbook, when the new copy is opened
all cells with other cell references in change to VALUE! and the formulas
point to the previous weeks workbook.

to test this out I made another copy, and brought it home, opened it on my
pc and everything was fine. I was expecting the same problem to occur on my
home pc, so I could explain the problem a bit clearer to you. hope this
makes sense to someone !!

Kind regards,
Steve
 
I don't have a guess, but maybe you could post some of the formulas you use and
a little more detail on what you do.

When you say you add a new worksheet, is that via Insert|worksheet or copying
and pasting from a different workbook.

When you populate the cells, do you copy and paste from an existing worksheet
(in a different workbook)?
 
Back
Top