Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

OK, I know it sounds complicated, so I will try and elaborate:

I have a lot of files (one created every day) - let's call them W1, W2... Every file has the same number of sheets and their names are the same - S1, S2...

I have to add a new sheet to every file. I did that at one of the files, but when I copy the sheet (select everything and then paste it to the new file) the formulas contain the name of the first file: SUM([W1]S1!...), but I want it to say SUM(S1!...)

I guess it is easy, but can't figure it out, and google didn't help me either.

Thanks in advance.

share|improve this question

You didn't say the version (pre or post ribbon), but in Excel 2010:

Go ahead and paste as you are, and then Data->Edit Links -> Highlight the W1 reference-> Change Source button

Point it at itself (W2: the target/new file), and the external links should be removed.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.