I created a macro that imports data from my accounting system into
individual worksheets in a workbook. Now, I would like to remove the Data
Range from these sheets, so no one refreshes the data. How do you do this
without deleting the contents?

Can't you just delete the macro? Or is it a query? If it's a query, you
would right click from within the data range, choose data range properties,
and unselect Save Query Definition.

"Squid" wrote:

I created a macro that imports data from my accounting system into
individual worksheets in a workbook. Now, I would like to remove the Data
Range from these sheets, so no one refreshes the data. How do you do this
without deleting the contents?

Just a couple of guesses (I have no idea what 3CDaemon is).

First, Get a copy of Chip Pearson's CellView Addin so that you can really
determine what's in DD04):
http://www.cpearson.com/excel/CellView.htm

Second, when I type a formula like:
=if(dd04="N",1,0)

The DD is changed to uppercase and the 0 is dropped:
=IF(DD4="N",1,0)

Does 3CDaemon create any bad (range) names (things that look like addresses)?

Try toggling this on, then off.
Tools|options|general tab|R1C1 reference style.

If you get a dialog box popping up saying that the name needs to be replaced,
you've found the source of your problem (maybe not the solution, though.)



There's an option that behaves kind of like what you write (but not exactly).

Tools|Options|Transition Tab
Uncheck "Transition formula evaluation"

(I uncheck all these Lotus 123 transition settings!)

=IF(DD4="N",1,0)
will evaluate to 1 if DD4 is empty under this setting.
it'll evaluate to 0 if DD4 is empty and the setting is turned off.)




TERRY TILLER wrote:

When I import sales data through 3CDaemon, I get cells that I of data that I
cannot use in formulas. It is like they are corrupted. But can copy the
info from cell to cell, just cannot use in formula (ex. =if(dd04="N",1,0.
Formula does not error out, but it makes no difference if N, U, or anything
else is in dd04. It answers back 0. How can I fix this ?

--

Dave Peterson