Changing SOP Allocation Method
We currently have all our order types set to allocate by line. We're
considering changing that to allocate by order/batch. Has anyone out there
made a similar process change? If so I'd like to know how you accomplished
the change and what problems you ran into.
Any suggestions on the easiest way to de-allocate lines?
You will need to update the SOP10100.ALLOCABY field for your unposted
transactions to make this change affect documents that have already
To de-allocate lines you need to run a query to update the ATYALLOC in
SOP10200 and IV00102...Desktop shortcut opens app but will not open file
When one of my users clicks on a desktop shortcut (MS
Excel), the program opens but the file will not. The
user can open the file directly by going into Excel and
clicking open , file, etc.
This are the usual things to fix this
Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again
If this doesn't work try to re-register Excel
Close Excel first and
On the Windows Taskbar
1 ) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space be...Word default paper size- networked user accounts
Word 2004- processors various, OS 10.5
How do I get Word to default to A4 (instead of US letter) for networked
The succinct answer to this is "By ensuring that your operating system
locality preferences are set correctly before you install."
Microsoft Office picks up all its global settings from the "Language and
Text" system preferences in OS 10.6 (I think they were called something else
If this has been done wrongly at installation, you need to set the System
Preferences correctly and then delete the individual user's...Excel 2007
We have a spreadsheet that was set up to link to a database via a
system DSN. To simplify deployment of this, I'd like to change this
to connect via the connection string below:
I've done this for another spreadsheet, and it was easy (Data tab-
>Connections->Properties), but in this next spreadsheet the Connection
Properties for one connection are greyed out/disabled, so I can't
change the string.
Does anyone have any ideas how to enable these values again so I can
change the connection string?
...Open outlook express eml files with Office Outlook
How can I get my Microsoft Outlook e-mail software to
open a Outlook Express .eml file save on a network. My
objective is to be able to double click the .eml file or
drag and drop it into my Microsoft Outlook application.
Lance <firstname.lastname@example.org> wrote:
> How can I get my Microsoft Outlook e-mail software to
> open a Outlook Express .eml file save on a network. My
> objective is to be able to double click the .eml file or
> drag and drop it into my Microsoft Outlook application.
You have to open in with Outlook Express and then move it to Outlook fro...Save word 2003
I run windows XP with word 2003. I recently performed a system reset with
some back up software. After which word 2003 wouldn't save any documents.
There is 2G of memory left on the C drive so it's not lack of space. I've
read other strings about this but can't find a solution, a previous string
talked about removing "Security Update for Windows XP (KB908531)" but I don't
have this in my list of updates (this advice was from 2006 though?)
Any help greatly appreciated.
See http://www.gmayor.com/what_to_do_when_word_crashes.htm then repair
Office 20...Outlook Crashes for Meeting Requests
User at firm is getting the generic "Outlook.exe has generated an
error message..." whenever they try to accept/decline meeting requests
in Outlook 2000 on Windows 2000 SP4 platform. Outlook will crash at
the precise time they select Accept, Decline, or Tentative.
Strange thing is that 2 of her AA's (on different machines!) get the
EXACT same error message when then they try and accept/decline
meetings for her. However they do NOT receive the error message upon
accepting/declining meetings for any others at the firm.
See below for Event Viewer log. Any help would be MUCH apprec...Hyperlinks have stopped opening in emails I receive
Have loaded new antivirus software having deleted older version and since
then I can not open any links that are included in emails
What happens when you try?
If you get an error about restrictions in effect, this is a problem with IE,
its not an Outlook error. You need to reset your internet settings in IE's
Tools, Internet Options, Advanced tab. (Or Control panel, Internet options,
See http://www.slipstick.com/problems/link_restrict.htm for the latest
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook &a...2003 Keeps the default workbook open
When I start Excel, it starts up with a blank workbook. If I immediately
open a saved file, it closes the blank workbook... All good...
except mine has stopped closing the blank one. So I always end up with 2
workbooks open, the one I opened and a blank one that I'm not interested in!
Is this a setting? if so where?
Can I fix it?
Did you or someone create a default workbook (ie, Book.xltx or
Book.xltm) and save it in
On 5/9/2010 4:17 AM, Michelle wrote:
> When I start...When launching Excel 2007 the VB debuger always opens
I am testing Excel 2007 Beta 2 on two computers.
On one of them, XP SP2 there is no problem. On the other, 2003 Server SP1,
each time I open Excel a VB window opens up, with a message that says
"Compile error: Cant find project or library."
If I close that window I get a message saying that the debugger will stop.
If I close that, Excel reacts normally.
Do you have any templates loading on the second computer?
What is shown in VB itself when you see the error message? Which module
are you in?
This sounds like...Outlook and Word
I just had to reinstall Office XP and know, when I open Outlook a blank MS
Word page come onto the screen. When I delete the page The Outlook screen is
there. I uninstalled the office xp and reinstalled the program and the same
thing happens. Is there any way I can get rid of this annoying problem
Thanks in advance
...Where to change my own internet adress in "FROM:" field?
I am using Outlook 2003 with Exchange server.
My own eMail address is presented to recipients as
Note: mixing of capital and lower letters
I want my email address completely changed to lower letters:
Where in Outlook can I change this?
or is this a setting in Exchange Server ?
This is a setting in ADUC/Exchange. I would guess that everyone is set up
with the same format throughout the company.
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outlook-tips.net/
"Joe deAngelo" wr...Outlook 2003 with Word 2000 Editor
Does anyone know if you can use Word 2000 with Outlood
2003 to edit messages...
I couldn't find a download on the web...
If you are trying to use, inside of Outlook 2003, Word 2000 as the
"editor" ... not possible. Need to use the same "family" together, e.g.
Word 2003 with Outlook 2003, or Word 2000 with Outlook 2000.
There is nothing to download.
Hope this is useful to you. Let us know.
Brendan Shaw wrote:
> Does anyone know if you can use Word 2000 with Outlood
> 2003 to edit messages...
> I couldn't find a download on the web...
...opening excel worksheet
Operating System: Mac OS X 10.6 (Snow Leopard)
whenever I try to open an existing excel worksheet it opens very short. I have to drag it down to the bottom of the screen, is there a setting that i need to adjust?
No, simply SAVE the workbook after you adjust it.
Next time, it will open at the size you want.
On 27/03/10 6:42 AM, in article 59bb6065.-1@webcrossing.JaKIaxP2ac0,
"email@example.com" <firstname.lastname@example.org> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> wh...Change QuickFind to search contains
Is there a way to change the QuickFind to use the contains operator
rather than begins with? Custom dev or third party recommendations
simply put a wildcard * in front of your search term in the query box and it
will match the defined search fields for that entitiy type on a 'like"
...can comment indicator color be changed?
Hi when you put a comment in a cell the indicator is red but I have cells
that are conditionally formatted to come up red if out of spec and can't see
the indicator. Can the color be changed and if so how please. Thanks Karl
AFAIK, no, you can't change this. Maybe you can change your CF color. Bright
On Wed, 27 Oct 2004 16:27:02 -0700, "Karl" <Karl@discussions.microsoft.com>
>Hi when you put a comment in a cell the indicator is red but I have cells
>that are conditionally formatted to come up red if out of spec and can't see
>the indic...Anyway to open a Publisher 2002 file in Publisher 2000?
I need to open this file for a project tomorrow. I have Publisher 2000, but I think the file sent to me was done in Publisher 2002 or 2003? The person who sent it to me is out of town until Thursday, so I can't have them resave it or resend it. Any ideas
buck <email@example.com> posted:
> I need to open this file for a project tomorrow. I have Publisher
> 2000, but I think the file sent to me was done in Publisher 2002 or
> 2003? The person who sent it to me is out of town until Thursday, so
> I ...mail merge in word 2000
Been trying to link a simple 4 column excel db to do a mail merge in Word.
Tried following the help instructions, and finally reached the point where I
could "insert a merge field" after realizing they left out a number of steps
in the instructions. However, when I do enter the mergefield, the only thing
I get is "Error! No bookmark name given." There is no mention of "bookmark"
in the instructions, no explanation of what a "bookmark" is in this context,
and now way I can figure out what the blasted software is talking about.
Anybody go...i can change the font on the screen to be large but can't print t.
i am trying to make the print on my spreadsheet larger. i can change the
font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!!
Maybe in the Page Setup you have this setting
"fit to1 by 1 page"
Regards Ron de Bruin
"tj" <firstname.lastname@example.org> wrote in message news:244325C6-A407-4CD8-BE76-75AB3C93A78A@microsoft.com...
>i am trying to make the print on my spreadsheet larger. i can change the
> font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!!
...how do i open a publisher file created in new version?
I get publisher files in new versions of publisher. I have publisher 2000.
I can't open these files but don't want to update publisher. Is there a
download program I can get to translate these files?
"Peg" <Peg@discussions.microsoft.com> wrote in message
>I get publisher files in new versions of publisher. I have publisher 2000.
> I can't open these files but don't want to update publisher. Is there a
> download program I can get to translate these files?
There is not a download to tra...words
what is the formula I use to copy a word from one cell to another cell. I
have the word spring and would like it to populate to other cells but do not
know the formula to do this
> what is the formula I use to copy a word from one cell to another cell. I
> have the word spring and would like it to populate to other cells but do not
> know the formula to do this
if you have a word in A1 and want it in A1..
in B1 put =A1
this formula will display the contents on another cell(word or number) in
what ev...Highlight color in Word 2008
Operating System: Mac OS X 10.5 (Leopard)
I wish to change the highlight color choices or their intensities in Word 2008 (not in Excel and not theselect-text color). Can one do this and, if so, how?
You just have to change the highlight color of the operating system! Word uses the OS highlight color. Go to system preferences > appearance & change the highlight color.
I think I was misunderstood. The highlighting I mean might be called background color. When one selects text, one can color the text, one can color the background, or both. My questions is ...Word windows 07 docs let's crash win for mac 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Hello, <br><br>I got a problem with my word docs. <br>
Everytime i would open and change something in my word doc (created on a pc) win for mac crashes. <br>
When? on the moment a insert a frontpage, indexpage. <br><br>Who got a sollution for me? <br><br>Kind regards
It's hard to say since you don't indicate;
Whether Office is fully updated on your Mac,
What your update level of OS X is,
What version of Word was used to create the document,
What f...How to remove contacts when email changes
If I receive an email from a sender not on my list, that sender's email
address is not automatically added to my contacts but will appear on the
automated list when I enter the first letter of the sender's email address.
If that sender changes email address I cannot delete the old email address.
Instead I am left with two email addresses for that sender both of which will
appear on the automated list. How can I remove the old email address?
You seem to be confused. Receiving an email does not add an address anywhere
in Outlook. Sending an email might, a...Changing Series names
Is there any way to change the titles of series in the chart and not on the spreadsheet?
If you want the legend text for the series to be different from the name
in the spreadsheet, try selecting:
and typing the new label in the 'name' box. This should break the
series name's link to the spreadsheet
Message posted from http://www.ExcelForum.com/