Replace All makes me look for a file!
 

I'm at my wits end here!! (insert me eating chocolate and drinking coffee)

I'm doing a simple find/replace. If I hit the 'replace' button so that it
replaces one cell at a time, I'm ok. HOWEVER, if I do a REPLACE ALL, a
screen (pops up that looks like the screen when you want to open or save a
file) and it's titled "unique value: input."

It won't let me cancel out of it or 'x' out of it (it keeps popping back
up), so I've tried choosing the file I'm working on, creating a new name for
the file, choosing a different file, but it just keeps going in circles and I
end up back at the original 'unique value: input" screen - the only way I can
get out is if I cont/alt/delete and shut down (and lose all my work :-(

I know its not what I'm trying to 'find' and 'replace' because it did work
once this morning already - however, there were like 58,000 replacements, so
I'm hoping I don't have to do this cell by cell!! ACK!

Help! :-)


--
tina

Replace All makes me look for a file!
 

OOPS - the screen pops up and says "UPDATE DATA:INPUT" Not Unique data:input"
--
tina


"tina" wrote:

I'm at my wits end here!! (insert me eating chocolate and drinking coffee)

I'm doing a simple find/replace. If I hit the 'replace' button so that it
replaces one cell at a time, I'm ok. HOWEVER, if I do a REPLACE ALL, a
screen (pops up that looks like the screen when you want to open or save a
file) and it's titled "unique value: input."

It won't let me cancel out of it or 'x' out of it (it keeps popping back
up), so I've tried choosing the file I'm working on, creating a new name for
the file, choosing a different file, but it just keeps going in circles and I
end up back at the original 'unique value: input" screen - the only way I can
get out is if I cont/alt/delete and shut down (and lose all my work :-(

I know its not what I'm trying to 'find' and 'replace' because it did work
once this morning already - however, there were like 58,000 replacements, so
I'm hoping I don't have to do this cell by cell!! ACK!

Help! :-)


--
tina

Replace All makes me look for a file!
 

If you're changing something that appears in a reference to another workbook (or
a different worksheet) and that workbook or worksheet doesn't exist, then you'll
be prompted for each error.

The only way I know to stop it is to kill excel through the task manager.

Without more info, I don't have any good advice.

tina wrote:

I'm at my wits end here!! (insert me eating chocolate and drinking coffee)

I'm doing a simple find/replace. If I hit the 'replace' button so that it
replaces one cell at a time, I'm ok. HOWEVER, if I do a REPLACE ALL, a
screen (pops up that looks like the screen when you want to open or save a
file) and it's titled "unique value: input."

It won't let me cancel out of it or 'x' out of it (it keeps popping back
up), so I've tried choosing the file I'm working on, creating a new name for
the file, choosing a different file, but it just keeps going in circles and I
end up back at the original 'unique value: input" screen - the only way I can
get out is if I cont/alt/delete and shut down (and lose all my work :-(

I know its not what I'm trying to 'find' and 'replace' because it did work
once this morning already - however, there were like 58,000 replacements, so
I'm hoping I don't have to do this cell by cell!! ACK!

Help! :-)

--
tina

--

Dave Peterson

Replace All makes me look for a file!
 

Just a guess...

If you close your workbook with macros disabled, does it work ok?

Maybe you have a misbehaving _change event that's firing for each change.

tina wrote:

OOPS - the screen pops up and says "UPDATE DATA:INPUT" Not Unique data:input"
--
tina

"tina" wrote:

I'm at my wits end here!! (insert me eating chocolate and drinking coffee)

I'm doing a simple find/replace. If I hit the 'replace' button so that it
replaces one cell at a time, I'm ok. HOWEVER, if I do a REPLACE ALL, a
screen (pops up that looks like the screen when you want to open or save a
file) and it's titled "unique value: input."

It won't let me cancel out of it or 'x' out of it (it keeps popping back
up), so I've tried choosing the file I'm working on, creating a new name for
the file, choosing a different file, but it just keeps going in circles and I
end up back at the original 'unique value: input" screen - the only way I can
get out is if I cont/alt/delete and shut down (and lose all my work :-(

I know its not what I'm trying to 'find' and 'replace' because it did work
once this morning already - however, there were like 58,000 replacements, so
I'm hoping I don't have to do this cell by cell!! ACK!

Help! :-)


--
tina

--

Dave Peterson

Replace All makes me look for a file!
 

the worksheet I'm referencing does exist, so that's not it :(

Again, if I go through and do a 'replace' cell by cell (just hitting the
REPLACE button and not REPLACE ALL), then, it will replace. If I hit REPLACE
ALL, then I get this screen that pops up that says on the top "update
data:input" and it wants me to either create a file or choose a file - both
of which I tried but when I complete the task, it just goes back to it's
original "update data:input" screen.

Looks like I"m just going to have to hit REPLACE 58,000 times!! Frustrating
:-(
--
tina


"Dave Peterson" wrote:

If you're changing something that appears in a reference to another workbook (or
a different worksheet) and that workbook or worksheet doesn't exist, then you'll
be prompted for each error.

The only way I know to stop it is to kill excel through the task manager.

Without more info, I don't have any good advice.

tina wrote:

I'm at my wits end here!! (insert me eating chocolate and drinking coffee)

I'm doing a simple find/replace. If I hit the 'replace' button so that it
replaces one cell at a time, I'm ok. HOWEVER, if I do a REPLACE ALL, a
screen (pops up that looks like the screen when you want to open or save a
file) and it's titled "unique value: input."

It won't let me cancel out of it or 'x' out of it (it keeps popping back
up), so I've tried choosing the file I'm working on, creating a new name for
the file, choosing a different file, but it just keeps going in circles and I
end up back at the original 'unique value: input" screen - the only way I can
get out is if I cont/alt/delete and shut down (and lose all my work :-(

I know its not what I'm trying to 'find' and 'replace' because it did work
once this morning already - however, there were like 58,000 replacements, so
I'm hoping I don't have to do this cell by cell!! ACK!

Help! :-)

--
tina

--

Dave Peterson

Replace All makes me look for a file!
 

Unfortunately I'm not running any macro's on the program, so that's not it....
--
tina


"Dave Peterson" wrote:

Just a guess...

If you close your workbook with macros disabled, does it work ok?

Maybe you have a misbehaving _change event that's firing for each change.

tina wrote:

OOPS - the screen pops up and says "UPDATE DATA:INPUT" Not Unique data:input"
--
tina

"tina" wrote:

I'm at my wits end here!! (insert me eating chocolate and drinking coffee)

I'm doing a simple find/replace. If I hit the 'replace' button so that it
replaces one cell at a time, I'm ok. HOWEVER, if I do a REPLACE ALL, a
screen (pops up that looks like the screen when you want to open or save a
file) and it's titled "unique value: input."

It won't let me cancel out of it or 'x' out of it (it keeps popping back
up), so I've tried choosing the file I'm working on, creating a new name for
the file, choosing a different file, but it just keeps going in circles and I
end up back at the original 'unique value: input" screen - the only way I can
get out is if I cont/alt/delete and shut down (and lose all my work :-(

I know its not what I'm trying to 'find' and 'replace' because it did work
once this morning already - however, there were like 58,000 replacements, so
I'm hoping I don't have to do this cell by cell!! ACK!

Help! :-)


--
tina

--

Dave Peterson

Replace All makes me look for a file!
 

I'm still guessing that the workbook/worksheet doesn't exist after you make the
change.

In my simple tests, I got a dialog with a caption of:
Update Values: book2.xls

When it was looking for book2.xls

Maybe it's time to double check that workbook/worksheet.

Or share the string -- before and after -- that causes the error.

tina wrote:

the worksheet I'm referencing does exist, so that's not it :(

Again, if I go through and do a 'replace' cell by cell (just hitting the
REPLACE button and not REPLACE ALL), then, it will replace. If I hit REPLACE
ALL, then I get this screen that pops up that says on the top "update
data:input" and it wants me to either create a file or choose a file - both
of which I tried but when I complete the task, it just goes back to it's
original "update data:input" screen.

Looks like I"m just going to have to hit REPLACE 58,000 times!! Frustrating
:-(
--
tina

"Dave Peterson" wrote:

If you're changing something that appears in a reference to another workbook (or
a different worksheet) and that workbook or worksheet doesn't exist, then you'll
be prompted for each error.

The only way I know to stop it is to kill excel through the task manager.

Without more info, I don't have any good advice.

tina wrote:

I'm at my wits end here!! (insert me eating chocolate and drinking coffee)

I'm doing a simple find/replace. If I hit the 'replace' button so that it
replaces one cell at a time, I'm ok. HOWEVER, if I do a REPLACE ALL, a
screen (pops up that looks like the screen when you want to open or save a
file) and it's titled "unique value: input."

It won't let me cancel out of it or 'x' out of it (it keeps popping back
up), so I've tried choosing the file I'm working on, creating a new name for
the file, choosing a different file, but it just keeps going in circles and I
end up back at the original 'unique value: input" screen - the only way I can
get out is if I cont/alt/delete and shut down (and lose all my work :-(

I know its not what I'm trying to 'find' and 'replace' because it did work
once this morning already - however, there were like 58,000 replacements, so
I'm hoping I don't have to do this cell by cell!! ACK!

Help! :-)

--
tina

--

Dave Peterson


--

Dave Peterson