Locking data between worksheets

M

mamorellana

I have an excel 2003 worksheet (main) linked to several worksheets
(secondary).
I want to retain the actual values in the secondary worksheets whenever I
modify the primary/main worksheet. The links contains dates and whenever I
add/move/delete rows in the primary worksheet, the secondary worksheet mess
up the dates.

How can I protect the information so I can retain the data in linked cells?

Thanks!

Marcela
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Syncing between source worksheet and dependent worksheets 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
How to modify a primary worksheet linked to another worksheet 7
Help? with extracting unsorted data from a worksheet, no blank lin 4
data links on subsequent worksheets 2
Cell data entering slow! 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0

Top