How to seperate worksheets so each displays on different monitors
When I open two excel worksheets they open up in a excel window. I can't
seperate them to view them on seperate monitors. I was able to view the
worksheets in seperate windows on different monitors until lately. Not sure
what I did to change the view.
Open up a seperate session of XL. I.e., open first file, then open up another
session of XL, and from there open the 2nd file. They should now be two
*Remember to click "yes" if this post helped you!*
> When I open two excel worksheets they open ...Can we tell which cell an image is on?
The user is clicking on a button that says "HIDE"
and when the user hits it.. it hides the row where the button exists.
IS THERE A WAY I CAN DO THIS?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Are you talking about an image or a CommandButton? If it's a CommandButton,
you can use code like this:
Private Sub CommandButton1_Click()
.Hidden = Not .Hidden
End With...Replied to or Forwarded Icons not displaying
A user has a wierd problem. Occasionally, when she either replies to or
forwards an email two things are not displayed:
1) the envelope icon does not show the red or blue arrow to indicate
that the item has been replied to or forwarded yet the item appears in
the sent items folder
2) When you open the item up from the sent items folder it does not
display the "you forwarded/replied to this email on" information bar at
the top of the mail.
The client is Outlook 2003 running on Windows 2000 workstation SP4.
I don't even know when to start looking as when she forwarded a
non...Good Visual Display of Project Dependencies
I am looking for a way to visually display dependencies between different
tasks within a project. (more than just the standard 'critical tasks'
report.) Does anyone have a interesting way to display this in some sort of
graphic chart that is appropriate for 'management'? (exporting into excel or
powerpoint, etc would be just fine.)
Did you try View/Network Diagram?
You can filter in the Gantt Chart view to display only a select group of
tasks. Then when you go to the network view you will only see the filtered
There is a companion ...How do I print only one item on a page instead of multiple.
I'm trying to print out a badge in publishing on XP pro. and I only want to
print out 1 badge and not a repeat of the same badge on the page. This was
easy to do on 98 pub., all I had to do was x out the ones I didn't want on
page preview. Is there a way to do this or am I goint to have to waste a
> I'm trying to print out a badge in publishing on XP pro. and I only want to
> print out 1 badge and not a repeat of the same badge on the page. This was
> easy to do on 98 pub., all I had to do was x out the ones I didn't want on ...Zoom to increase display size on received mail
Recent new user of Micosoft Office Outlook 2007 (Beta) 12.0.4017.1006 MSO
When composing a new message, in the Format Tab there is an option to Zoom
to change the display size. On reading recieved mail there is no similar
option as far as I can find. For the older amongst us with declining visual
ability, this would make it easier to read incoming messages. In Outlook
Express there is a facility to increase the Text Size from the View Menu
which is just fine!
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the...Multiple Pivot tables from One selection
I would like 2 or 3 pivot tables to use on pivot table selection. I.e
the selection criteria of the 1st pivot table on the menu page
determines what the page data of the other pivot table displays on
seperate sheets where the other pivot tables are contained. So the
selection of one pivot table controls the rest.
dapo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29967
View this thread: http://www.excelforum.com/showthread.php?threadid=496616
Check the "Synchronize 2 Piv...Date Wont Display As Date
This is a simple one, I hope.
Here is the problem formula:
I am trying to get this formula to show as:
Instead I get:
Any ideas on how to get the date to show and not the date code?
Pick one of your liking.
"Minitman" <email@example.com> wrote in message
> This is a simple one, I hope.
> Here is the problem formula:
>...Multiple Batch processing in Great Plains
As Great Plains is still posting timesheets and I am trying to post another
timesheet in PDK for week beginning 3/7 it comes up with an error message
“Your batch for this period has been marked for posting. You can no longer
save documents to it.”
I presume this is because Great plains is still trying to process a batch
for that period and therefore cant accept more at the moment. Would i be
correct in this presumption or can i process further batches?
...Mail Merge for Multiple Pages of Contacts
My contacts for a mail merge for labels consist of multiple pages. I know I
can export to Excel and do the mail merge from there; however, Is there any
supported way from CRM to carry all contacts over for the merge? Thanks.
Unfortunately, this was a design limitation of the CRM V3 mail merge.
Microsoft Dynamics CRM
This posting is provided "AS IS" with no warranties, and confers no rights.
"DStella" <DStella@discussions.microsoft.com> wrote in message
> My contacts for a m...how do i import multiple data sets at one time?
I'm importing a bunch of data and I'm using the import external data command
in the data menu. I click on my file and choose delimited and then add a
space in the next screen. It turns out to be two columns of data. I do this
10 times and was wondering if there is a way to import all the data at one
time to simply save time. If anyone out there has any ideas I'd love to hear
them. Thanks in advance.
Assuuming that the files are all of the same two-column format, in a DOS
Command Prompt window:
Copy File1.txt + File2.txt + File3.txt + File4.txt + File5.txt
File2Import.tx...unable to display the folder. an unexpected error occurred
I use outlook to view mail on a groupwise server. when i
open the mailbox or the calandar i get "unable to display
the folder. an unexpected error occurred". i can view
the notes folder and the tasks folder. i can also see
that i have unopened mail, but when i try to open the
mailbox, i get the above error. any solutions? please
help. thank you.
I am currently managing an Exchange 5.5 box that is servicing mail for two
domain names...lets say @company1.com and @company2.com. Is there a way to
set up the Exchange box to allow the message specific changing of the "reply
to" address? In other words, my internal client receives a message that was
sent to firstname.lastname@example.org and when he replies it shows that it came from
email@example.com. The next message he receives was pointed to
firstname.lastname@example.org and when he replies it will show that it came from
email@example.com instead of firstname.lastname@example.org.
Not supported in Ex5.5.
Wit...Printing multiple reports per ID
I am trying to figure out how to print multiple reports per ID ("Username",
text field). I guess it would be like packets of reports. I am passing
values to the report through the Where statement that I obtain by looping
through a multiselect listbox ending up with a string resembling:
[Username] IN ("Value1", "Value2", ...)
I imagine I have to loop through the reports as I loop through the
Usernames. I just can't sort it out in my head.
Appreciate the help in advance.
Well, it depends a bit on exactly what you want. If the print ...Protecting Multiple Worksheets
Is there a way to protect more than one worksheet at a
I think you need only protect the worksheets you want
protected: select menu\tools\protection\protect worksheet
for each worksheet.
>Is there a way to protect more than one worksheet at a
This macro will protect all the sheets that are selected:
Public Sub ProtectSelectedSheets
Const PWORD As String = "drowssap"
Dim wkSht As Worksheet
For Each wkSht In ActiveWindow.SelectedSheets
wkSht.Protect Passwor...if SUM = zero, then display nothing... how?
I want the cells to display no number, not even a zero, if there is no
value. How can I do this?
"Bryce" <email@example.com> wrote in message
> I want the cells to display no number, not even a zero, if there is no
> value. How can I do this?
Format the cells to something like General;General;
The trailing semicolon indicates that zeros are not to be displayed.
Tools/Options/View/deselect Zero Values.
"Bryce" <fuk...Multiple Versions
Can Excel save multiple versions of a file automatically (as opposed to using
Save --> As)?
No, Excel doesn't have a version feature similar to the one in Word.
> Can Excel save multiple versions of a file automatically (as opposed to using
> Save --> As)?
Excel FAQ, Tips & Book List
> ...as opposed to using Save --> As)?
Just throwing out an idea that I use. If you wish, you could run a macro
that makes a Copy of your workbook using the "SaveCopyAs" command. The
advantag...OWA The page cannot be displayed
I have a 2003 front-end OWA server running with 2 2003 exchange server
running behind it. If I have a user that is on the first exchange server OWA
works great, but if they are on the second exchange server they get "The page
cannot be displayed". Any ideas why this would be happening? Everything else
seems to be fine. No Outlook or email issues that I am aware of other then
Any ideas would be great!
Was the front-end server just implemented?
From the mailbox server experiencing the problem, try accessing owa locally
through http://local...multiple monitors & dialogue boxes
Using Dynamics GP 8.0 - If multiple monitors are in use, dialogue boxes (e.g.
"do you want to save changes" - yes, no, cancel) only pop-up in the primary
monitor, not the monitor displaying Dynamics GP. Dialogue/message boxes
should pop-up inside the Dynamics GP window so you don't have to mouse over
to the other screen to click them.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, fol...unable to display system files
When I load up outlook a pop up informs me that outlook cannot open up the
default email files... I cannot use outlook for email at all... I cannot use
the options tab in the tools menu...
State your Outlook version.
State whether Outlook ever worked.
If so, state what you did just before it stopped working.
Outlook is telling you it cannot find or access it's data file. Only you
would have a clue why that might be. Is your Outlook data on an Exchange
server or stored on your local machine?
> When I load up outlook a pop up ...Multiple USB Devices on ASUS
I am having an odd problem and don't know if it can be resolved. I
recently built a new machine using ASUS P5G41-M with 4GB RAM, an Intel
Core 2 Duo 3GHz processor, and a 380W PSU, running Windows XP SP3. The
old Machine was an ASUS P5L-VM, with 2GB RAM, an Intel Pentium D
processor, and a 350W PSU, running Windows XP SP3r.
I set up the following USB devices on the New PC exactly as I had on
the old PC:
1) USB Wireless Mouse
2) Logitech PC Camera
3) HP Laserjet P2015 Printer
4) HO Officejet 6310 AIO Printer
In addition I have now added:
5) 500...counting rows across multiple worksheets
I am trying to count and add all rows populated with values across multiple
worksheets. Is there an easy way to do this?
The *easiest* way is to perform the count and/or the totaling on each
individual sheet in the *same* relative cell.
So, say the count is displayed in X100 on *all* sheets,
And the sum is displayed in X101 on *all* sheets.
On the main sheet, use formulas similar to these:
Please keep all correspondence within the Group, so all may benefit!
=======================...How do I plot multiple 3D surface charts
I have created a 3D image of a subsurface reservoir using the 3D surface
chart. I would like to add additional images to the same chart, so that the
chart will illustrate overlying subsurface reservoirs.
I have attempted to do this using Chart - Add data
but the resulting chart will display my original data ... the new data is
displayed as a vertical wall.
Is it possible to display more than one 3D surface image on a single chart
XL's 3D surface charts are pretty limited in what one can do with them.
You may be able to create 2 separate charts and then mov...Problem displaying a form that runs queries
In Access 2007, I’m having a little issue displaying a form that runs
queries on load. Below is my code.
When I double click the form, the queries begin to run but the form only
appears after the queries are done.
If I put the code behind a command button it works fine. I can’t use a
command button because I need the queries to run unattended when the DB
opens. Where am I going wrong?
Private Sub Form_Open(Cancel As Integer)
DoCmd.MoveSize 2880, 4320
Private Sub Form_Load()
'QUERIES ...Multiple instances of Outlook when executing multiple DoCmd.SendObject commands
Hello! The routine below works great when I send only one email. But
when sending another email, I have to kill Outlook via Task Manager
is immediately replaced by another session of Outlook and Outlooks
Any help or suggestions appreciated!
Sub Send SendEmail()
On Error GoTo Err_Command11_Click
Dim stDocName, mTO, mCC, mSubject As String
stDocName = "frmSnapShot"
mTO = Forms!frmEmail!emailTO
mCC = Forms!frmEmail!emailCC
mSubject = Forms!frmEmail!Subject