Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
I noticed that if I have multiple instances of Excel, the copy and paste
functions behave differently. Specifically, if I have two instances running and I try to copy from one instance to the other, it only copies values and not the formulas. First, is this normal or is just me and my environment? And second, what other difference are there, if any? Thanks. Regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
"David Z" wrote in message ... I noticed that if I have multiple instances of Excel, the copy and paste functions behave differently. Specifically, if I have two instances running and I try to copy from one instance to the other, it only copies values and not the formulas. First, is this normal or is just me and my environment? And second, what other difference are there, if any? Thanks. Regards Before spending any more time (yet) figuring this out, please click Tools, Options, View tab, and find "Windows in taskbar". If it's checked, UNcheck it. Let me know if that eliminates the "instances", as you're calling them. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
If you do all your work in one instance of excel, then the copy and paste will
work the way you want. If you have two instances open, the one instance of excel just sees it as a copy from any other windows program--it doesn't have any idea what application it came from. David Z wrote: I noticed that if I have multiple instances of Excel, the copy and paste functions behave differently. Specifically, if I have two instances running and I try to copy from one instance to the other, it only copies values and not the formulas. First, is this normal or is just me and my environment? And second, what other difference are there, if any? Thanks. Regards -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
But you could still copy and paste via the formula bar, if languages and
other settings like list separators and reference styles are identical. -- Kind regards, Niek Otten "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. If you have two instances open, the one instance of excel just sees it as a copy from any other windows program--it doesn't have any idea what application it came from. David Z wrote: I noticed that if I have multiple instances of Excel, the copy and paste functions behave differently. Specifically, if I have two instances running and I try to copy from one instance to the other, it only copies values and not the formulas. First, is this normal or is just me and my environment? And second, what other difference are there, if any? Thanks. Regards -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
Aaahhh, that makes sense. Thanks Dave. And thank you Doug as well.
"Dave Peterson" wrote: If you do all your work in one instance of excel, then the copy and paste will work the way you want. If you have two instances open, the one instance of excel just sees it as a copy from any other windows program--it doesn't have any idea what application it came from. David Z wrote: I noticed that if I have multiple instances of Excel, the copy and paste functions behave differently. Specifically, if I have two instances running and I try to copy from one instance to the other, it only copies values and not the formulas. First, is this normal or is just me and my environment? And second, what other difference are there, if any? Thanks. Regards -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
"Dave Peterson" wrote in message
... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
I don't like to do this either. I find it a pain.
So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
I'm running Excel 2000. Unless something has changed in later versions,
Excel is happy to churn things in one workbook, while you're viewing another, all in one instance. "Dave Peterson" wrote in message ... I don't like to do this either. I find it a pain. So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
One reason could be if you need Excel-wide settings to be different, like
Reference style and Calculation mode -- Kind regards, Niek Otten "Dave Peterson" wrote in message ... I don't like to do this either. I find it a pain. So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
Would these different settings be persistent from one startup of the program
to another? If so, how would a user designate which "profile" to start, since all icons point to the same .EXE file? "Niek Otten" wrote in message ... One reason could be if you need Excel-wide settings to be different, like Reference style and Calculation mode -- Kind regards, Niek Otten "Dave Peterson" wrote in message ... I don't like to do this either. I find it a pain. So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
No, you'd have to set them (or one of them) and keep them open all day.
BTW it still doesn't solve all issues; some settings are at Windows level, like date formats (US vs. European) and list separators. -- Kind regards, Niek Otten "Doug Kanter" wrote in message ... Would these different settings be persistent from one startup of the program to another? If so, how would a user designate which "profile" to start, since all icons point to the same .EXE file? "Niek Otten" wrote in message ... One reason could be if you need Excel-wide settings to be different, like Reference style and Calculation mode -- Kind regards, Niek Otten "Dave Peterson" wrote in message ... I don't like to do this either. I find it a pain. So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
Are you telling me that your macros continue running when you're editing cells
in other workbooks? And that calculation will continue in one workbook while you're busy typing away in another? I don't recall any version of excel that allowed that. Calculation would always be interrupted if I did something with the mouse/keyboard. Doug Kanter wrote: I'm running Excel 2000. Unless something has changed in later versions, Excel is happy to churn things in one workbook, while you're viewing another, all in one instance. "Dave Peterson" wrote in message ... I don't like to do this either. I find it a pain. So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson -- Dave Peterson |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
Calculation mode and reference style are picked up when you open the first
workbook. You could always change those to opposite settings manually (in each instance). Doug Kanter wrote: Would these different settings be persistent from one startup of the program to another? If so, how would a user designate which "profile" to start, since all icons point to the same .EXE file? "Niek Otten" wrote in message ... One reason could be if you need Excel-wide settings to be different, like Reference style and Calculation mode -- Kind regards, Niek Otten "Dave Peterson" wrote in message ... I don't like to do this either. I find it a pain. So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson -- Dave Peterson |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
Another advantage of multiple instances (well, to some people) is that
if you close the Excel window you only close the one file that it contains - rather like Word. Pete |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
From what I can tell, yes, although I don't have macros than run for more
than perhaps 30 secs. Could this be an error in perception? "Dave Peterson" wrote in message ... Are you telling me that your macros continue running when you're editing cells in other workbooks? And that calculation will continue in one workbook while you're busy typing away in another? I don't recall any version of excel that allowed that. Calculation would always be interrupted if I did something with the mouse/keyboard. Doug Kanter wrote: I'm running Excel 2000. Unless something has changed in later versions, Excel is happy to churn things in one workbook, while you're viewing another, all in one instance. "Dave Peterson" wrote in message ... I don't like to do this either. I find it a pain. So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson -- Dave Peterson |
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
I think so.
If you just try a macro with simple endless loop, I think you'll see the difference. Option Explicit Sub testme() Dim i As Long Dim j As Long For i = 1 To 1000000000 j = i + 1 Next i End Sub Hit ctrl-break to get out of it. Doug Kanter wrote: From what I can tell, yes, although I don't have macros than run for more than perhaps 30 secs. Could this be an error in perception? "Dave Peterson" wrote in message ... Are you telling me that your macros continue running when you're editing cells in other workbooks? And that calculation will continue in one workbook while you're busy typing away in another? I don't recall any version of excel that allowed that. Calculation would always be interrupted if I did something with the mouse/keyboard. Doug Kanter wrote: I'm running Excel 2000. Unless something has changed in later versions, Excel is happy to churn things in one workbook, while you're viewing another, all in one instance. "Dave Peterson" wrote in message ... I don't like to do this either. I find it a pain. So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
All depends on how hectic your workbook is. Excel has various internal
limits that will slow it down big time depending on what you have going on, but all these limits are specific to that instance of Excel, so opening up another one can allow you to do something that your current instance may struggle to cope with as well. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Doug Kanter" wrote in message ... I'm running Excel 2000. Unless something has changed in later versions, Excel is happy to churn things in one workbook, while you're viewing another, all in one instance. "Dave Peterson" wrote in message ... I don't like to do this either. I find it a pain. So I asked someone who asked how to do this and their reply was so that they could work in one instance while excel did stuff (long calculations/long running macro) in the other. Doug Kanter wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... -- Dave Peterson |
#18
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
I am running Excel 2000 and recently have experienced separate instances of Excel opening each time I open a file or create a new one. Why does this happen and how do I change it back to having only one instance open? -- j-dawg ------------------------------------------------------------------------ j-dawg's Profile: http://www.excelforum.com/member.php...o&userid=16551 View this thread: http://www.excelforum.com/showthread...hreadid=516331 |
#19
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Instances of Excel
Wow! Why would anyone want multiple instances??? Are you kidding?
I am a fast worker. My ideas come out fast, and I need to get them down fast. Working in Excel, I often want multiple excel spreadsheets open. On it's own, simply "arrange all" and you are on your way. But, I'm an engineer, so if I'm working on Excel, it's only because it eventually needs to get put into a ppt slide or a word doc. Here is where the trouble begins, even with my dual displays. Without being able to open an xls or ppt in it's own instance, one has absolutely no control over what things they can see in which spot. For instance, my boss wants a brand new copy of a presentation I did last week, but with a new design template and updated information. To accomplish this, I need two ppts open, often an xls open, and likely a couple of window browsers. If, like has been suggested, I expend the effort to open the two ppts and arrange them to fit nicely together, then how do I read from the excel? Pull up the xls and start typing in the ppt and I lose the xls (thanks to my 2-screen ppt). Resize ppt down, insert pieces of information from the xls, and try to move the ppt back? This is a miserable waste. I work in a restricted environment, so I can't simply get two installations of ppt or anything else for that matter. I can't get outside software. So I'm stuck being completely frustrated by my inability to control Office. To me, and many of my engineer friends, this is one of THE BIGGEST deficiencies in Office. If you want to discuss more, please send me a message. "Doug Kanter" wrote: "Dave Peterson" wrote in message ... If you do all your work in one instance of excel, then the copy and paste will work the way you want. Why would anyone WANT to run two instances? Is there any advantage at all? I see it done by mistake quite often..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine multiple excel file in to one excel file and multiple worksheet | Excel Discussion (Misc queries) | |||
combine multiple excel file in to one excel file and multiple worksheet | Excel Discussion (Misc queries) | |||
Prevent Excel closing all workbook instances when clicking on "X" | Excel Discussion (Misc queries) | |||
Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) |