Anyone know anything about Excel? When I open an Excel spreadsheet the program opens normally, when I open another spreadsheet it opens in the same Excel window. How do I get my new spreadsheets to open in new Excel window ( 2 Excel programs running)? I'm using Office 2003.
22  25234 
I gave up. I had the reverse problem (only wanted one window). Never did figure where they put that setting.
Barton what version are you using? I will let you know if I find a solution.
Anyone know anything about Excel? When I open an Excel spreadsheet the program opens normally, when I open another spreadsheet it opens in the same Excel window. How do I get my new spreadsheets to open in new Excel window ( 2 Excel programs running)? I'm using Office 2003.
Aric
If I remember correctly this is a windows setting. For instance if you have windows running to open new window each time it will open new windows application each time. However, if you have windows to replace current window with new one it will open in the same application.
However, if you are doing this in code it is slightly different.
Mary
Aric
If I remember correctly this is a windows setting. For instance if you have windows running to open new window each time it will open new windows application each time. However, if you have windows to replace current window with new one it will open in the same application.
However, if you are doing this in code it is slightly different.
Mary
Mary,
I'm not doing this in code I'm talking about opening two spreadsheets in two seperate windows of excel. I want to do this so I can span two across two monitors and compare the data.
Thanks let me know if you have a fix for this,
Aric
Aric
If I remember correctly this is a windows setting. For instance if you have windows running to open new window each time it will open new windows application each time. However, if you have windows to replace current window with new one it will open in the same application.
Mary
This makes perfect sense. It would be in keeping with M$'s integration strategy to make this an explorer setting and would explain why I was never able to find it.
Barton what version are you using? I will let you know if I find a solution.
I use OpenOffice now. I don't buy any M$ software except the OS.
Mary,
I'm not doing this in code I'm talking about opening two spreadsheets in two seperate windows of excel. I want to do this so I can span two across two monitors and compare the data.
Thanks let me know if you have a fix for this,
Aric
Try this.
Open any windows folder then go to Tools - Folder Options. Under the General tab change the Browse Folders setting to 'Open each folder in it's own window'. You may have to reboot for the change to take effect.
Mary
Anyone know anything about Excel? When I open an Excel spreadsheet the program opens normally, when I open another spreadsheet it opens in the same Excel window. How do I get my new spreadsheets to open in new Excel window ( 2 Excel programs running)? I'm using Office 2003.
Hi Aric,
Try this one. In Excel, Go to Tools, Options, in View Tab, check on the Windows in Taskbar, then hit OK.
Hope this helps.
regards,
link :)
Hi Aric,
Try this one. In Excel, Go to Tools, Options, in View Tab, check on the Windows in Taskbar, then hit OK.
Hope this helps.
regards,
link :)
Great answer link.
I forgot that was there, sorry Aric.
Mary
Hi Aric,
Try this one. In Excel, Go to Tools, Options, in View Tab, check on the Windows in Taskbar, then hit OK.
Hope this helps.
regards,
link :)
Some combination of this and Mary's trick + rebooting worked on mine not my co-workers. Cooperate windows or die!
Some combination of this and Mary's trick + rebooting worked on mine not my co-workers. Cooperate windows or die!
I have a feeling it's one of those inconsistancies that can crop up in windows 'occasionally'.
Mary
I take it back the Windows in task bar only shows that you have two excel spreadsheets open. If you check/uncheck that you will have two spreadsheets not two excel programs. I'll continue looking and let you know if I find something. Again, we're looking to have 2 Excel programs open where we can show 2 spreadsheets side by side ( think dual monitors 1 spreadsheet a piece )
Thanks,
Aric
I take it back the Windows in task bar only shows that you have two excel spreadsheets open. If you check/uncheck that you will have two spreadsheets not two excel programs. I'll continue looking and let you know if I find something. Again, we're looking to have 2 Excel programs open where we can show 2 spreadsheets side by side ( think dual monitors 1 spreadsheet a piece )
Thanks,
Aric
You can do this by opening the application twice and then opening the spreadsheets from within the applications.
You can do this by opening the application twice and then opening the spreadsheets from within the applications.
Yeah but that is such a pain!
Yeah but that is such a pain!
Since you are actually trying to open two instances of the application there is really no way around this outside of using VBA code to do it for you.
Mary
Thanks mmccarthy...
I really don't get it but try this one also, Aric.
if you already opened two excel program and trying to view two spreadsheets at the same time, right click on the taskbar then select tile windows horizontally or tile windows vertically.
hope I got it right.
Regards,
Link
Some combination of this and Mary's trick + rebooting worked on mine not my co-workers. Cooperate windows or die!
Or OpenOffice!
Or OpenOffice!
I have Openoffice too! and it's portable...which means I can run OpenOffice without installing it. :D
Or OpenOffice!
Lol that's not an option.
Try this.
Open any windows folder then go to Tools - Folder Options. Under the General tab change the Browse Folders setting to 'Open each folder in it's own window'. You may have to reboot for the change to take effect.
Mary
Hello everyone
This is my first time at this forum ( I have to tell you guys that i'm not good at writing lol. )
I agree with Mary very much!
Regards
Jacky.
Anyone know anything about Excel? When I open an Excel spreadsheet the program opens normally, when I open another spreadsheet it opens in the same Excel window. How do I get my new spreadsheets to open in new Excel window ( 2 Excel programs running)? I'm using Office 2003.
See if this helps you:
http://www.drewery.net/blog/2006/08/29/utilising-dual-monitors-with-microsoft-excel-2003/
See if this helps you:
http://www.drewery.net/blog/2006/08/29/utilising-dual-monitors-with-microsoft-excel-2003/
Yeah actually I think that will work. Nice job been buggin me for awhile.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: jimserac |
last post by:
I had previously posted this in an Access forum
with negative results so will try here.
Although this question specifies an Access database,
I also wish to accomplish this with a large MS SQL...
|
by: Sam Johnson |
last post by:
HI
I tried to send the following SQL string to an open
databse, to export a table into excel format:
g.Connection = conn 'valid OleDBConnection and Command
objects
g.CommandText = "SELECT *...
|
by: George |
last post by:
Sub ExcelToListBox()
Dim xRange As Object
Dim ary
Dim xValue As String
xRange = oXL.Range("A1:A9") 'has letters A-H
ary = xRange.value
xValue = ary(3, 1) 'xValue = C...
|
by: wreckingcru |
last post by:
I'm trying to output a SQL query that is constructed thru my VB.net GUI
into an excel file.
Here is the code I'm using:
'Sqlstmt is the SQL query statement
'Conn is the SQL Connection object...
|
by: Mad Scientist Jr |
last post by:
>From an asp.net web page I want the user to open the results of a SQL
query in Excel, as automatically as possible (ie not having to loop
through columns, rows, in code).
For this,...
|
by: Gunawan |
last post by:
Dear All,
I have create an excel (COM Object) using this code
Excel.Application xls = new Excel.Application();
but I can not remove it from memory although I have using close and quit
...
|
by: Doug Glancy |
last post by:
I got the following code from Francesco Balena's site, for disposing of Com
objects:
Sub SetNothing(Of T)(ByRef obj As T)
' Dispose of the object if possible
If obj IsNot Nothing AndAlso...
|
by: ddecoste |
last post by:
I have a need to add a visual representation to some data in Access.
I need to draw a matix of squares inside another square. I have all
the data that I need in a record in Access. The data...
|
by: pleaseexplaintome_2 |
last post by:
using the code below (some parts not included), I create a new excel
workbook with spreadheets.
I then want to delete a spreadsheet, but a reference remains open and
excel stays in task manager...
|
by: akristensen |
last post by:
I am new to this site, so be patient if I do not ask the question correctly.
Current Target Platform: Browser: MS IE, script language: Javascript (will use VBScript, but JS is preferred), External...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
