Hi folks,
I have a spreadsheet that pulls in links from three other spreadsheets.
Everything keeps shifting or I am losing the links.
Questions:
When I insert new rows, to add new data sets that I will then link, will all the links that were previously linked "after" the inserted row be lost?
Is this what is causing it?
I have columns set up like this and the dates are linked to other spreadsheets:
Name1, Date 1, Date 2, Date 3
Name2, Date 1, Date 2, Date 3
Name3, Date 1, Date 2, Date 3
So, the names are sorted in alpha order. When I insert a new row to add a new name, say between Name2 and Name3, and insert the new date links, does this cause my other links to be lost?
Is there a way to prevent this? I hope I was clear enough...
Vince
I have a spreadsheet that pulls in links from three other spreadsheets.
Everything keeps shifting or I am losing the links.
Questions:
When I insert new rows, to add new data sets that I will then link, will all the links that were previously linked "after" the inserted row be lost?
Is this what is causing it?
I have columns set up like this and the dates are linked to other spreadsheets:
Name1, Date 1, Date 2, Date 3
Name2, Date 1, Date 2, Date 3
Name3, Date 1, Date 2, Date 3
So, the names are sorted in alpha order. When I insert a new row to add a new name, say between Name2 and Name3, and insert the new date links, does this cause my other links to be lost?
Is there a way to prevent this? I hope I was clear enough...
Vince
