Excel linking between workbooks

Not something I've done much of over the years. In fact I've avoided it where possible. However, I have a spreadsheet with masses of worksheets, and among them some chart sheets or worksheets with charts (there's a distinction).

I'd like to have the chart sheets and/or the sheets with charts copied to another workbook, for public publishing, obviously keeping back the data sheets.

Ideally, once setup, I would open main workbook, change any data (charts within would change too), then open chart workbook, and have it sync with master workbook, then save both and publish the latter, updated.

2007 btw.

S'ok.

Worked it out.

Since you're the forum Excel guru we would all be sweating a bit if you couldn't work it out.

I am?

Yay!

In reply to a post by camieabz:

I am?

Yay!

The one that I can't work out is how to link to another sheet within the same workbook..?
It's should be obvious, but...., not to me
Thanks,
Martin

One of the problems IME of linking between workbooks is if you should change in any way the full path of linked-to workbook.

Probably due to me being more disorganised than you and deciding to change a file or folder name .

Why not simply output the Chart Sheets and the Charts on Worksheets to PDF Files?

That way, you totally avoid transferring any data, which appears to be the object of the exercise.

In reply to a post by martinsq:

The one that I can't work out is how to link to another sheet within the same workbook..?
It's should be obvious, but...., not to me
Thanks,
Martin

Lets say you have a sheet called 'abc' and a sheet called xyz. If you wanted to link to a cell in xyz (e.g. A1), type in a cell:

=xyz!A1

or just type in a cell '=', then navigate to the source sheet, then click on the source cell, then click enter.

I know. It's a good point. My current project is on the desktop, and if I want to move it to a folder later, I'll have to fart around with that.

Well I want some data in chart publish form, without outputting the raw data. So I don't want to mess around with hiding/unhiding sheets or passwords everytime I make a change. Equally I want all my publish data on the document.

I may output the second workbook to PDF (or HTML).