T
tbraddy
I have a worksheet that has user input to calculate data that will be
put into a database for testing. The worksheet also has a Get External
Data to get that data once the test has run.
I'm trying to preserve the formulas and outputs by protecting the
cells, but when I protect the worksheet, I can't get external data.
Is there a way to protect some cells on a worksheet, but still get
external data on that same sheet? For now, I can put it on a
different sheet, but I would like to have it all on one sheet.
Todd
put into a database for testing. The worksheet also has a Get External
Data to get that data once the test has run.
I'm trying to preserve the formulas and outputs by protecting the
cells, but when I protect the worksheet, I can't get external data.
Is there a way to protect some cells on a worksheet, but still get
external data on that same sheet? For now, I can put it on a
different sheet, but I would like to have it all on one sheet.
Todd