Finding links in a workbook

[RichardMGreen]

Hi all

I've got a template workbook which contains loads of formulas which are updated daily.
I then have a macro which exports most of the sheets and converts them to values only to produce an output file.

When I open the output file to check it, I get a message asking if I want to update the links (which I can't find and shouldn't be there).

How can I find where the link is so I can get rid of it?
I have this line of code in my macro:-
wb.BreakLink Name:=Template, Type:=xlExcelLinks

which forces an error.

I've checked all the sheets to see if there's any linked tables or cells referring to my original workbook but I can't find anything.

Any help greatly appreciated.

::edit::

Just to add, there's no links in my template workbook so it's definitely something peculiar in the output file.

 

[GlennUK]

Worksheet Move the sheets then?

 

[RichardMGreen]

Never thought of doing it that way.
I'll give it a go and see what happens.