Opening a new instance of ExcelI am using multiple monitors for work and it is great! Is
there a setting that I can use so that it opens each new
excel file in a new excel window so I can drag different
ones to each monitor? Is there a similar setting for Word?
I am using Excel 2002 and Word 2002.
Thank you.
Hi,
Yes, you can check the Windows in Taskbar checkbox in
Tools; Options. This is on the View tab for both Word
and Excel.
>-----Original Message-----
>I am using multiple monitors for work and it is great!
Is
>there a setting that I can use so that it opens each new
>excel file in a new excel ...
Creating and Organization Chart from and excel fileI was able to create an org. chart awhile ago and now when I try to use the
org. chart wizard and select the excel file I get an error "cannot read
names". I have excel and visio 2003. Can anyone help???? I want to include
4 fields from from excel file (name, title, department, reports_to). Help!
Have you tried creating an Excel file recently? Perhaps there's an issue
with your existing Excel file. I'd try generating a dummy file using the
wizard, and then try importing it iback nto a new Visio file using the
wizard. If that works, then you may want to cut / pas...
Too many rows for Excel output from Access 2000All:
In my application I am exporting several records to excel file
dynamically using a query,when the number of records exceeds 50000 records
in one of the scenarios I am getting this error :There are too many rows to
output, based on the limitation specified by the output format or Microsoft
access
Dim stDocName As String
stDocName = "Query11"
DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, , 1
Can any one suggest the solution to this problem,
Thanks in Advance,
VT
IIRC, OutputTo uses an earlier Excel format that limits to 16K rows.
Use the TransferSp...
Importing Data into an Excel Pivot Table via AccessI have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...
VBA from another app: Suppressing Excel confirmation dialog?After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
.Worksheets("Sheet1").Delete
.Worksheets("Sheet2").Delete
.Worksheets("Sheet3").Delete
.Worksheets("Sheet4").Delete
On Erro...
Illegal operation error while printing EXCEL or WORD FilesHi,
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
networked printer.
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...
how do I add times in Excel and result in hours & minsI want to insert a time when I start work and a time when I take a break,
then a time when I leave work.
Following that I want to be able to add up the amount of hours that I have
worked.
This will enable me to plan my week ahead and ensure I only allocate a
specific amount of time to a project.
http://www.cpearson.com/excel/datetime.htm#WorkHours
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message
news:37D03D72-5525-4D6E-8ED7-2911B16248B0@microsoft.com...
>I want to insert a time when I start work and...
How can I drop a flyer from Publisher into PowerPoint as a slide?I have created a flyer in Publisher but I now need to drop it into PowerPoint
as a slide, is this possible?
No, not really. You could open up both instances, Powerpoint and Publisher,
and then drag and drop/copy and paste from the Publisher window to the
Powerpoint window, the reformat as needed.
--
Brian Kvalheim
Microsoft Publisher MVP
http://www.publishermvps.com
This posting is provided "AS IS" with no warranties, and
confers no rights.
"melann" <melann@discussions.microsoft.com> wrote in message
news:58EE1229-ED29-4A5F-B4D6-BDE863876DB0@microsoft.com...
&...
Contacts onto a Mysql databaseHello,
I am in the process of transfering data and contacts onto a Mysql database.
I have had some help and am trying to get a software solution.
So main features would be to migrate large amounts of data and contacts
every day. The migration would be done manually.
Thanks for the help
On Tue, 4 May 2010 08:53:01 -0700, Guertas <Guertas@discussions.microsoft.com>
wrote:
>Hello,
>
>I am in the process of transfering data and contacts onto a Mysql database.
>I have had some help and am trying to get a software solution.
>
>So main features woul...
can't send anything in Outlook 2002I just sent a post asking for help because I can no
longer send email with attachments. After sending in the
post, I went back to Outlook and clicked on the
Send/Receive button just to check if I had any new mail.
I got the same message: "The operation failed". So I am
totally out of business with Outlook. How to solve the
problem? Marilyn
Did it work before? Did you change anything in yr settings? Are you sure
your internet mail account settings are valid (correct username, pw,
smtp/pop3 servers)?
------------
"Marilyn Fogelquist" <fogel@cablespeed........
Emailing in excel 2003 02-26-10If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
date.
Thanks.
Check out Ron De Bruins "Send-Mail" tips:
http://www.rondebruin.nl/sendmail.htm
Micky
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
>
> The email body should say: this has been submitted for cell B34 and...
How can Journal be used if Project is not installed, or on the netHow can Journal be used if Project is not installed, or on the network
--
Rusty Nichols
Network Support Technician
The Journal folder works without Project being installed at all. It's an
integral part of Outlook. What functionality are you seeking?
"Rusty" <w_r_nichols_iii@yahoo.com> wrote in message
news:7EA79673-AE35-44D2-A09E-EBF73E7EC414@microsoft.com...
> How can Journal be used if Project is not installed, or on the network
How can Journal potentially affect the Exchange server, and I would like more
information on Journal for a Outlook foundation class?
...
Does anyone have a dashboard gauge (speedometer style) for Excel?I am trying to create dashboard charts from Excel data and would love other
templates not available in Excel today - speedometer charts, multi-dimension
comparitive charts, charts that build information overlays.
I regularly create these in a manual way for executive and customer
summaries but would appreciate the ability to automatically generate these
types of charts allowing for real time viewing of "what if" scenarios.
Steve, there are tons of these things out there to review, few better than
this collection:
http://www.andypope.info/charts.htm
Andy Pope has put together...
Excel CrashI use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
this?
...
Import Palm filesCan anyone help me by telling me how to import palm files
(dat files) into outlook. I want to import contact,
calendar, etc
Depends what you can export to from Palm Desktop. Personally, I've found
this messy. Why not just get sync software that can sync your Palm with
Outlook directly? Chapura Pocketmirror or Pumatech Intellisync are two
ideas....or your Palm CD may have come with this option.
F. Carvalho wrote:
> Can anyone help me by telling me how to import palm files
> (dat files) into outlook. I want to import contact,
> calendar, etc
...
EXCEL TROUBLESHOOTING #2I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
problem ?
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...
Excel Edit F2 button changed for Mac???Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <1176582208.958694.269620@q75g2000hsh.googlegroups.com>,
ssears@indy.tds.net wrote:
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...
In Excel program shows a broken line and don't know how to get ri.I am trying to put in entries in Excel program and when I go to Print
Preview, it only shows part of the entries I put in. When I go to the last
entry that it shows in Print Preview, there is a broken line between it and
the next entry. I don't know what I did. I could use some help
You probably have multiple areas selected for your print area.
you can check this by <view><page break preview>
One possibility to correct this would be
<file><print area><clear print area>
or specifically select the area you want printed and
<file ><Print area>...
Excel Cells Contents to HTML Pages
Hi,
I have an excel sheet which has two columns.
Column 1: PageName
Column 2: HTMLCode
PageName has information like: OurServices.htm which is the name of th
HTML page.
HTMLCode clumn has actual HTML Code like:
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html
charset=windows-1252"> ...
How can I tell if our GP 9.0 is updated to the latest SP and patchWe recently upgraded our GP to 9.0, but I'm not sure we are at SP1 or the
latest patches have been installed. Is there a way to tell from the versions
numbers displayed in the "About Microsoft Dynamics GP" box? Or, maybe asked
a different way, if at the latest updates, what should the Dexterity and GP
9.0 version numbers be at?
hello,
You know if it's Dynamics GP SP1 when you see that:
Dynamics GP - 9.00.0259
Dexterity - 9.00.0068.0
rgds,
timber
On Oct 6, 6:35 am, dcnjoe60 <dcnjo...@discussions.microsoft.com>
wrote:
> We recently upgraded our GP to 9.0, bu...
Contact use?I am studying at moment and would appreciate confirmation of below,
company has an external consultant who has an internet mail address of
Bill@isp.com , company wants to receive all mail addressed to him and do not
publish his private internet mail address as they do not want customers to
contact him directly, the solution suggested is below.
create a mail-enabled contact object for Bill and specify two addresses,
Bill@company.com "@company.com being organisation email address" and
Bill@isp.com, for this contact. All messages that are addressed to
Bill@company.com will fir...
Contact not importing names of csv listsWhenever I import a csv file into outlook 2007 it imports only the email
addresses, nothing else. I've titled the csv columns with the exact same
headings as the outlook contact headings. Still, it imports only the email
addresses. What do I need to do to get it to import the full names as well?
Is it correct to assume that because you stated that you "titled the csv
columns the same as the Outlook contact headings" - that you used
"auto-map" to import your data?
There is absolutely no reason, benefit or value whatsoever (under any
circumstances) in ...
How Can I Tell What Button Was Just Clicked?
I have a bunch of images on the sheet that calls ONE function.
Is there a way I can tell which button was clicked within the
function?
I'd hate to make a function for each image.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
See one technique at your other thread.
kenji4861 wrote:
>
> I have a bunch of images on the sheet that calls ONE function.
>
> Is there a way I can tell which button was clicked within the
> function?
>
> I'd h...
Does anyone know where I can download EXCEL.MSI?I am missing my Excel 2002 CD, and can't install Office Update Service Pack 3
without this file.
...
How can I instantly delete emails? I get a strikethrough + purge
...