can't open file #3I recently saved a file, when i wanted to open it nothings comes up. I dont
know if the file is corrupted, i tried to recover but it didnt work. The last
time i used was two days ago, and enter some data and saved it as usual, i
dont know what's going on. Can anyone tell me what should i do?
Alicia,
You don't say which version of Excel you're using. 2002 and 2003 can repair
damaged workbooks in some situations. Try File - Open, and look for a
drop-down in the "Open" button. If you have it, try "Open and repair." Try
opening it in a later version. Em...
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 to get SUMPRODUCT on filtered cellsI'm currently using the formula
=SUMPRODUCT((F2:I1475>=1)*(F2:I1475<=9999))
This gives me the number of the full range of cells but I need this to
update whenever I use a variety of filters.
Any help is greatly appreciated
Sam.D
Say we have data in A1 thru B29 like:
flia value
0 pass
2 pass
1 pass
2 pass
1 pass
2 pass
0 pass
2 pass
1 pass
2 pass
1 pass
0 pass
2 pass
0 pass
1 pass
1 fail
1 fail
0 fail
2 fail
1 fail
0 fail
1 fail
2 fail
1 fail
1 fail
1 fail
1 fail
2 fail
and are appling autofilter to column a. We want to use sumpr...
Windows Live Email Time StampThe windows live time stamp on all outgoing emails is 4hours later than the
actual time. PC time is setup with the correct time zone. Only happens when
using the online windows live email access. Can anyone assist?
Thanks.
v "dioncnr" <dioncnr@discussions.microsoft.com> schreef in bericht
news:68BCFE8E-74E3-4967-B733-209DCE7C3BED@microsoft.com...
> The windows live time stamp on all outgoing emails is 4hours later than
> the
> actual time. PC time is setup with the correct time zone. Only happens
> when
> using the online windows live ...
Quirky recent file list #2
Debra---
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
Stacie
--
SPenney
------------------------------------------------------------------------
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
changed. <g>
If/when you upgr...
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........
Outgoing emailsI am having an issue when trying to send emails out....
It has been working fine until about 2 weeks ago. Please help.
Message appears as follows.....
-- The connection to the server has failed. Subject 'test', Account:
'mail.aapt.net.au', Server: 'mail.aapt.net.au', Protocol: SMTP, Port: 23,
Secure(SSL): No, Socket Error: 10060, Error Number: 0x800CCC0E
Try port 25. If you still get an error post back. There are cases where
that doesn't work either and you need to change it, and another option as
well . . . . let's just try one thing at ...
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 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...
&...
How do i get outlook to update hotmail account without reopening?
the tedster <the tedster@discussions.microsoft.com> wrote:
<nothing>
Ask your question in the body of the message.
Without reopening what? Outlook? Hotmail? The short answer is "you
can't".
--
Brian Tillman
...
Linking a graph to a csv file**Excel 2002
Hello, I'm sure this is exceedingly easy, but somehow,
I'm screwing this up. I ultimately need to have a self-
updating PowerPoint file (client mandates a ppt file).
According to ppt's help, that means I have to use linked
Excel graphs, not embedded ppt graphs. However, my
programmer will be supplying me with tons of csv files.
When I try to create an excel file with a data link to a
csv file, it tells me that it can't update it unless I
open the source file. I *can't* take the time to open
each csv - there will be hundreds. What am I missing
wi...
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
...
Outgoing emails not sending for outlook express 2000Hi there,
Can anyone help me?Everytime I try to send an email these
error messages pop up and I have no idea what to do;
The host 'SMTP' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'SMTP', Protocol: SMTP, Port: 25, Secure(SSL): No,
Socket Error: 11001, Error Number: 0x800CCC0D
The host 'POP3' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'POP3', Protocol: POP3, Port: 110, Secure(SSL):
No, Socket Error: 11001, Err...
DB Emailing Questions1) How do i format the message text of an email in Access. I used macro
builder - action = sendobject. Can you use code builder? if so, please give
me an idea of how the code will be like.
2) Also can i assign the email to have a recipient automatically or do i have
to write it down each time?
Thank you in advance.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1
On Jan 21, 11:51=A0am, "axm0035 via AccessMonster.com" <u56602@uwe>
wrote:
> 1) How do i format the message text of an email in Acce...
Getting List of Visible WindowsHi All,
I am working on a problem that requires me to know whether or not any
part of a particular window is visible (even if it's like a one pixel
corner). In my misunderstanding, I thought that ::IsWindowVisible
would cover it, but it looks like that call just verifies that the
hWnd actually has a dialog box. I was able to take it a step further
and find out whether or not a window is minimized using
::GetWindowPlacement, but I really need to find out if a window is
visible or not (in other words, not completely covered by higher
z-order windows).
Is there some sort of API call that ...
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?
...
Outlook 2003Hello.
I copied my PST file from my D: drive to my F: drive.
I then went into "Data File Management" to get the new location
recognized and to have all future mail sent to that location.
After doing this, my custom settings, like new folders, date
settings, columns, etc, are all back to their default settings.
Is there any way I can get my custom settings working again on the F:
drive?
Thanks,
Dan
Could you explain yourself a bit more? What custom settings are you refering
to? You mean views? And what new folder settings?
Also post your version of Outlook.
--
Robert Spar...
Why do I get four postcards to the same person when I mail merge?I merged my Excel document with my Publisher document just now and did a
print preview, but the 4-up view shows that all 4 are heading to the same
person.
How do I tell Publisher that each "up" is a different address?
If you are using 2003, this is a bug. If you are unsure there is a test print on
the print dialogue screen. Use plain paper for the test.
If you are using 2007, be certain you select multiple pages per sheet.
--
Mary Sauer
http://msauer.mvps.org/
"Batmantis275" <Batmantis275@discussions.microsoft.com> wrote in message
news:324C9E10-38C9-4DA0-89C...
outlook 2000 help fileSeems after I did added SP3 from MS upgrade site my help from outlook has
quit working. message is msohelp caused error in itss.dll. help works in ALL
other programs including outlook address book. I'm running windows 98 SE,
Office 2000 SB and IE 6.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/03
...
Outlook should be able to email MS CRM advanced find queries (grouThe only way to e-mail a group in MS-CRM is to use the Quick Campaign
function. The Quick Campaign has several disadvantages:
- attachments for emails are not possible
- this takes at least about 10 more clicks compared to sending a standard
outlook email
- the quick campaign doesn't have the look-and-feel of Outlook to which
users are accustomed to
Therefore it would be great if you could select the emailaddresses from
groups retrieved from MS CRM into the TO:, CC: or BCC: field in a standard
Outlook email message. Actually you would make the advanced find queries
available to sel...
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...
Getting Started With BarcodesHi,
We've just opened our second retail clothing store. This expansion
means we're going to have to start using barcodes to keep track of our
inventory (inventory is now entered into RMS manually). The issue is
we have no idea how to get started. Is there some sort of primer on
barcodes and supply-chain management that we could use as a starting
point? Does anyone have any suggestions/experiences with barcodes and
RMS they'd be willing to share? We'd really like to build this thing
properly from the start.
TIA
Well, first let me ask this question. Does most of your i...
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>...
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...
A rule that places a new email in a sub Folder doesnt get displayedCreate a folder; Create a rule that moves new mails to that folder; Happy
as larry. When a new mail arrives, outlook shows a blue numeric value next
to the folder to indicate unread messages.
However, if you add another folder to the folder created above, ie a sub
folder and create a rule to move new email, you have to have the tree fully
extended to be informed of a new email.
Is there a way to see if an new email has been sent to a sub folder without
having the tree list expanded?
Cheers
Phil
What version of Outlook and what Service Pack level?
--�
Milly Staples [MVP - Outloo...