vba excel - Linked sheets

Resolved · Low Priority · Version Standard

Fri 9 Feb 2007, 15:23 Delegate Colin said...

Colin has attended:
Excel Intermediate course

Linked sheets

How do I break links betweet linked sheets and still keep the data bought accross in the files saved with other names

Mon 12 Feb 2007, 12:04 Trainer Amanda said...

RE: linked sheets

Hi Colin

Thanks for your question.

You can go to Edit - Links in the file that contains the links in order to manage how the links in the workbook operate.

Amanda

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips