Linking spreadsheets

  • Thread starter Thread starter sbg1275
  • Start date Start date
S

sbg1275

Hi,

Not sure if this can be done but this is what my boss is trying to do:

Have two worksheets.
Worksheet A is a shared worksheet.
Workshop B has cells linked to figures in worksheet A.

All good so far, but....

If someone using the shared worksheet deletes or adds a row it messes
up worksheet B.

EG:

Worksheet B adds together figures from Cell 1B and 3D in Worksheet A.
Joe Bloggs comes along and deletes row 2.
This means that Cell 3D actually becomes Cell 2D and the equation no
longer works.

I don't think there is a way around this if the worksheet is to
continue being shared.
Am I wrong?!
 
Fix the sharedbook so they can't delete cells or rows.... or is that
not an option?
 
You must log in or register to reply here.

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

Deleting Row 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Worksheet Names using Macros 5
Hide columns based on row values 2
IF function 4
When a cell is blank, add another 2
criteria to filter and extract row data into separate worksheet 1
have an entire row populate with a link when the data in a cell ch 1

Back
Top