Re: Question about Paste Special

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you make sure that you open fileB in the same instance of excel as fileA,
you'll be ok.

So close everything but fileA.
Then File|Open FileB.

And then do your copy|paste special.

===
Sometimes windows/excel can get confused when you're opening a workbook by
double clicking on it in windows explorer. It won't see the already running
instance of excel, so it'll just start a second instance of excel and open the
file in that.

If you want to change this behavior, sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.



Mike1000 wrote:

Hi, thanks for the response.

I'm sorry I don't understand, but what is considered a distinct
session?

For example right now I opened File A, opened File B. I also just
started a 3rd file(no file name, new workbook). All in all, I have 3
distinct? files opened. For some reason when I try and copy data from
File A and Paste special into my new workbook, I get the options in the
second scenario I described, but when I copy data from File B and paste
special into my new workbook, I get the first scenario I described.

Is there a way I can avoid this, or find some consistency?

Thanks in advance.

--
Mike1000
------------------------------------------------------------------------
Mike1000's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36701
View this thread: http://www.excelforum.com/showthread.php?threadid=564372

--

Dave Peterson
.

Quantcast