Import data into protected worksheet

R

RalphM

I would like to import external data into unlocked cells in a protected
worksheet.
The data from an external piece of test equipment is always in the same
format, so I have blocked out cells for the import. These cells are
unlocked. The formulas to analyze the data are to be protected. When I
protect the sheets, the DATA import function is grayed out, so I can't
import. Is there some way to do what I want?
 

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

Dealing with the error: unable to filter on excel hc home school 0
corrupted formula in protected worksheet 21
Creating a Chart on form from selected data in query. 0
Inserting a comment box in a protected worksheet 1
Enabling Autofilter and Sorting in a Protected Sheet 2
How to prevent Cut&Paste to change style and data validation on protected sheet 2
Protected sheet - attempt to delete row = unmerged cells 5
How to change format protection default to unlocked? 2

Top