How to control Word to open files in Draft layout and Document Map
I can't find how to control this. Sometimes for a long period all documents
open in Draft mode which is what I want but sometimes they open in other
layout modes and I have to constantly switch to Draft layout mode. Also the
same happens with the Document Map view that appear on the left side. I used
to have all documents open with that Document Map view but currently for
about a month all documents open with Thumbnails view and I have to always
switch to Document Map view every time.
> I can't find how to control this. Sometimes for a long period all
...Remove PO or AP TRX from FA TABLE
If a PO or an AP transaction is posted to FA clearing account by mistake how
can a revesal be made and the correct accout be recorded for the transaction
if we have Post Thru GL for AP. If we delete from teh table or use the purger
purchasing transaction option what happends to the transaction?and how does
it get posted to the correct account?
...office 2004 (excel & word) afp file path issue on tiger server (10.4.9)
we have just changed over to an xserve (running 10.4.9, HFS+ with
ACLs) and are experiencing the following problem with office 2004
excel & word files only - surprisingly powerpoint files are not
all excel and word files without spaces in either file- path or -name
open just fine, however all files with spaces in file-path or -name
generate the following error message...
alt="excel error message" />
for the above we used the following example file:
-rwxr--r-- 1 daniel...do no split table across pages
How do I make a table NOT split across pages without adding a page
The last row goes on the next page.
I might add text above so adding a page break is not a good solution.
Can we clarify - you DONT want a table to extend to a new page.
The following article has tips on how to control tables extending across
Hope this helps
> How do I make a table NOT split across pages without adding a page
> The last row goes on the next page.
> I might add t...Pivot tables and dynamic columns
I am using pivot tables and pivot reports to analyze survey data
imported from our customer survey program into Excel. This works well
but the problem is we periodically add new questions to the survey,
which then causes the columns to shift and messes up our pivot tables.
What�s the best way to deal with the shifting columns, so that we do not
have to redo the pivot tables every time we make a change to our survey?
Is there a way to base the pivot table data range on the column header
name, rather than Excel�s column letter?
---------------------------------------...i forgot how to make my business card insert for word documents?
i had to restore my software and I read somewhere how to have my salutation
on my word docs into a buisness card insert, can anyone help?
...Word Document to Excel
I have a large mailing list that was formatted in Word in a table. I would
like to export it into Excel. Thanks for any help.
You should be able to just select all (Ctrl A) and then copy and paste it
"D. Hockenberry" wrote:
> I have a large mailing list that was formatted in Word in a table. I would
> like to export it into Excel. Thanks for any help.
...How Dialog Can Check Thread Status?
I am beginning a thread when a button is pressed in a
modal dialog. I want to be able send status back to the
dialog so I can display it in a edit box. The thread is
running a test on a SCSI device so I want to display
status as test progresses. Any help on how I might go
about accomplishing this would greatly be appreciated.
I am noivce windows programmer so please bare this in mind.
Steve Heck wrote:
> I am beginning a thread when a button is pressed in a
> modal dialog. I want to be able send status back to the
> dialog so I can display it in a edit box. The thread is...Moving paragraphs from MS Word to Excel
In excel is there an alternative to using format|wrap text? I was
wondering if it's possible to insert text from a word document into
excel and have lines automatically cut off after a specified limit of
characters/"whole words" - as it would appear in MS Word. For instance,
if the first paragraph in my word document had 580 characters, I'd like
to paste it into excel. Then I figure you can use a combination of
trim, mid, and other text functions (that I'm unaware of) to return a
specific range of characters.
Let's say cell A1 had 580 character paragraph, a...Please Help
i put vba textbox in word 2002, i exit design mode and saved BUT..
every time i open it up it opens up in design mode!!!!!
what can i do to make the file open not in design mode???
i thought off writing in document_open : close the design mode, but i
dont know the code line.
all answers will do..
I bet you'd get better answers in an MSWord newsgroup (as opposed to an Excel
> i put vba textbox in word 2002, i exit design mode and saved BUT..
> every time i open it up it opens up in design mode!!!!!
> what can i do to mak...Encrypt a Word document in VBA
I want to create a macro that in certain situations will encrypt the current
document such that when the document is saved and opened again, Word will ask
for the password (similarly to the user selecting the Office Button ->
Prepare -> Encrypt Document).
Would someone tell me how this can be done? Thanks for any help.
To set a password ...
ActiveDocument.Password = "whatever"
To save with a password ...
ActiveDocument.SaveAs name_etc., Password:="whatever"
"JeffG" <JeffG@dis...How can I remove a word from the dictionary in Windows Live Mail?
I made a mistake by adding a word in the dictionary of Windows Live Mail.
Now I would like to remove that word, but I don't know how.
Can somebody give me an advise?
Anneke (I am dutch)
Tools | Options | Spelling | Edit.
Imperial Beach, CA
"Anneke" <email@example.com> wrote in message
> I made a mistake by adding a word in the dictionary of Windows Live
> Now I would like to remove that word, but I don...Sorting pivot table drop-down
I notice that the drop-down menu for one of the fields of a pivot table is
randomly arranged. I like for it to be ascending or alphabetical order. Do
you know what order it is sorting in (is it based on the order of the source
data?) and is there a way to get it to sort alphabetically?
If you sort the field, the dropdown menu should also be sorted.
To sort the field, select a cell in the field, and click the A-Z button
on the Excel toolbar.
> I notice that the drop-down menu for one of the fields of a pivot table is
> randomly arranged. I like for it to be...Deleting XML Record from Dataset removing table?
When I delete the last record from my dataset and then WriteXML() to the
file; the Table itself, in the xml file, is removed. I need to prevent the
table structure from being deleted if there are no more records to be
written to the XML file from the Dataset.
Any ideas here,
"John" <firstname.lastname@example.org> wrote in message news:eEDs6IW4FHA.400@TK2MSFTNGP09.phx.gbl...
> When I delete the last record from my dataset and then WriteXML() to the file; the Table itself, in the xml file, is removed. I
> need to prevent the table structure from being deleted
...Word in Office 2000 will not shut down properly when using Windows
I recently upgraded my computer running Windows XP to one operating Windows
7. I had no problem installing Office 2000. It works fine, but Word will not
shut down properly when I close the program. I get a dialogue box from
Windows saying the program is no longer responding and Windows is searching
for a solution. After Windows conducts its search, another dialogue box comes
up with a "close program" button. I click that and then it shuts downs. Any
help would be appreciated as I do not want to shell out $$$ to update Office
2000 when it otherwise works fine, except for...Win98SE and Comcast Hi Speed Internet (cable)?
Does anyone know if it is possible to get Comcast Hi Speed Internet (cable)
to work for Win98SE? They (Comcast) don't support it, but I was wondering
if that generic Win98SE USB driver (nusb) could work for a USB modem, or if
that depends on the specs of both the generic USB driver and which specific
cable modem you have (I doubt if any current cable modems come with any USB
drivers for Win98SE).
"Bill in Co." <email@example.com> wrote in
> Does anyone know if it is possible to get Comcast H...Click Entering Absolute Cell References into a Formula
When one is in the process entering a formula into an
EXCEL spreadsheet it is possible to click on another cell
to automatically have this cell reference placed into the
formula. However this entry always is entered as a
RELATIVE cell reference. Is there a way to have EXCEL
insert an ABSOLUTE cell reference into the formula??
It seems to me that it would be so common and yet I have
never been able to figure this one out.
Is this what you want?
Click the cell and then press F4.
F4 acts as a toggle going through the four reference options.
...Compare 2 Pivot Tables
I am wondering if there is a easy way to compare 2 pivot tables.
There have been many times where there is not a way to show a comparison of
2 sets of data in one pivot table.
What I have done in the past for scenario is to have a workbook that has 2
worksheets containing the 2 pivot tables.
I then have a 3rd worksheet that compares the data in the 2 pivot tables
This work fine in most cases however setting up the 3rd sheet can take some
One example of where I might want to compare 2 pivot tables: I have a Pivot
Table that shows the Score Test results o...Pivot Table #52
After creating a pivot table, I am left with the lead category (furthes
to the left) that is summaried. Iv'e tried to cut and paste to give a
Is there a way to set the pivot so it will fill the blank section
below Asia with "Asia"? Automatically, not by copy and pasting it in.
This used to be a feature in previous versions of Excel.
Please respond directly to firstname.lastname@example.org with the subject title o...Just one more table to link!!!!!!
Asyma Systems Inc.
I can help you but need more details. Can you email me the report at
"Kate Hulit" wrote:
> Kate Hulit
> Asyma Systems Inc.
If you are trying to link tables to a report and are finding it difficult to
create the relationship, you can always use VBA if you are registered for
Modifier & VBA to read the data directly from SQL.
Just a thought.
David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific
Micorosoft Dynamics (form...tables in word
Hi Can anyone help. I can't line up a column of figures on a decimal point in
my word table. They look terrible, as they're all over the place. Thanks.
"sharon" <email@example.com> wrote in message
> Hi Can anyone help. I can't line up a column of figures on a decimal point
> my word table. They look terrible, as they're all over the place. Thanks.
You need to ask in a discussion group for Word. This group is for .NET
Here's how to...I need 2 add a legend 2 pictures in a word or publisher document
can anyone help
My first suggestion would be to use proper words. Using cutesy shorthand is
Having said that - what exactly do you want to do? And in which program?
MVP Microsoft [Publisher]
"add legend to word or publisher document" <add legend to word or publisher
firstname.lastname@example.org> wrote in message
> can anyone help
Is this English?
"add legend to word or publisher document" <add legend to word or p...Word 2008 "Draft View" font drawing issues
Operating System: Mac OS X 10.5 (Leopard)
When I work in "draft view," which is most of the time, and I'm scrolling, the program often doesn't properly redraw the text. As a result, the ends of lines of text disappear or sometimes I see double images of text. I can redraw the text either by doing a "select all" or by flipping to "print layout view," both of which are complete time-wasters. <br><br>I didn't have this problem in Word 2004 when I was in "normal view,"...Pivot Tables #5
I am currently trying to create a pivot table for datas that are found from different worksheets.(not workbooks
Other than consolidatating the datas (via copy and paste) onto a new worksheet and designing the pivot table from there, are there any other methods that i can use
If i consolidate the datas onto a new worksheet, then i would need to create links to the orginal source, and i do not want to do this.
Can anyone plse help
Choose Data, Pivot Table and slect Multiple Selections
you can select a range from the first sheet with the ref
edit tool then add it to the li...Adding detail to record in a table in a secondary table
I have a table with acts payable records that basically have vendor ID,
Invoice Number, Invoice Date, Invoice Total. How can I create another table
that would have several records of data pertaining to above record that would
attach itself to the record. (Invoice Header / Invoice Data). Thank you.
On Fri, 15 Jan 2010 16:21:04 -0800, ramudo <email@example.com>
>I have a table with acts payable records that basically have vendor ID,
>Invoice Number, Invoice Date, Invoice Total. How can I create another table
>that would have several records...