ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Losing reference when deleting worksheet (https://www.excelbanter.com/excel-worksheet-functions/96631-losing-reference-when-deleting-worksheet.html)

Alex Mackenzie

Losing reference when deleting worksheet
 
I have a workbook with multiple worksheets. One of the worksheets contains
data that is used in formulas in the other worksheets. The workbook is
distributed to other people for them to use. When I need to update the data
with new values, I would like to be able to just send around the worksheet
for people to add to the workbook. But if they delete the old data worksheet,
the formulas all lose the link to the data. Is there a way I can reference
the data worksheet so that I can replace the old data worksheet with the new
data worksheet. There is a lot of data involved, so just cut and paste into
the workbook is not the preferred option. Thank you.


All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com