Saving Autorecover info in 2007 so SLOW!
I've had to disable it. Its soooo slow (eg 5 minutes and more to save
autorecovery info on a file that saves in under 30 seconds!).
Any ideas why so? I'm on Office 2007, Win 7 using files that were generated
years ago under Excel 2000 and have worked flawlessy prior to "upgrading" (ha
ha) to Office 2007.
All my macros, which operated much quicker after upgrading to Win 7 have now
come to a screeching slowdown since installing Office 2007 too, which i did
because 2000 just didn't seem to be comfortable under Win 7. I am soooo
seriously considering winding...want questions
I want some set of questions on Word-2007 to check competency level of the
user. Please help.
Ananta, please refer to my other 2 postings: just check out the WORD part.
If my comments have helped please hit Yes.
"Ananta Gupta" wrote:
> Hello Everyone,
> I want some set of questions on Word-2007 to check competency level of the
> user. Please help.
> Ananta Gupta
> Ananta, please refer to my other 2 postings: just check out the WOR..."TO" field, auto fill-in feature
my users have the "Suggest names while completing To, CC,
and BCC fields" checked which can be found from the main
OL interface by:
Tools>Options>Email Options>Advanced Email Options
my problem is that some of the names that have been used
previously no longer work. it will auto fill in the "To"
line with the correct display name from the Global
Address List but there is no SMTP address attached to it.
does anyone either now how to fix this or clear the cache
so i can see if starting from scratch will fix this?
Remove individual addresse...PurchasePrice field in table IV00102
Does anyone know why this field exists?
In our configuration, there are no values in it (all 0's).
I want to store a value (for informational purposes only) - specifically,
the item's standard cost per site.
I would greatly appreciate some opinions on this.
This is from the SDK on the CD:
Purchase price to use in determining which vendor to use when generating
purchase orders to replenish this item/site (only when POP Pricing Selection
is “Use Specified Price”).
> Does anyone know why this field exists?
> In our configur...I want more!
I need to extend a form that aleady has some 100 lines. For instance, one
column has the date, but only until tomorroq. How do I create more lines
based on the same formula?
I usually select the last row in the range and copy it down a few rows.
If you're using xl2003, you may want to look at Data|List.
And if you're using xl2007, this feature has transformed into Tables.
(Data tab on the ribbon|Data tools Group|What if Analysis|Data table)
> I need to extend a form that aleady has some 100 lines. For instance, one
> column has the da...IIF Record =
I'm trying to update a query expression and not having much luck.
The origional expression pulled a value from a Form and then based on that
value summed the values from another table.
Month08: Sum(IIf(Forms![Summary Reports]![Report Month]=8,[Sep]+[Oct],0))
Now I want to point this expression to another table (not a form) in order
to retrieve the value. Basically I want it to read.
Month08: Sum(IIf([Export_Data].[Month] = 8,,[Sep]+[Oct],0))
Now the Export_Data table only has one record that I am manipulating via
VBA. Any help is greatly apprechiated.
ther...need to make 3 fields into 1 field
I have an mail list that has been created with 3 address fields. These
fields need to be consolidated into 1 field. Can this be done.
=a1 & " " & b1 etc
"Georgia" <Georgia@discussions.microsoft.com> wrote in message
> I have an mail list that has been created with 3 address fields. These
> fields need to be consolidated into 1 field. Can this be done.
Most programs that use Adresses like them ...Not able to save changes to system settings
I have 3.0 with sample data. My issue is that I'm not able to save any
changes to the system settings. I have SA right. Any idea? Thanks.
This is normally caused by a incorrect SQL Reporting Services setup. Check
that your SRS Server is working, check that srs's url is well configured at
deployment manager. And if it doesn't solve the problem you should read this
> I have 3.0 with sample data. My issue is that I'm not abl...I don't want a page of the same label, I want one of each...
I can't find where to tell Pubisher that I want one of each label and not a
page of each label.
I'm using Publisher 2003 (Office 2003)
I see a post that says to enter "<<Next Record>>" but Publisher doesn't see
this as a field, just as text.
This can't be that hard, but I can't figure it out...
Any help would be appreciated.
I see that it prints correctly, but the print preview displayes it wrong....
I think I have it figured out...
"Kelvin" <email@example.com> wrote in message
news:OSpLwThUIHA.5508@TK2MSFTNGP04.phx....Makeing People Save As
I have an excel spreadsheet on a shared drive at work. When people in the
office open the file, is there a way to make them "save as" and not to be
able to type on the original file?
Thanks for any help in advance!!!
"=?Utf-8?B?RXJpYw==?=" <Eric@discussions.microsoft.com> wrote in
> I have an excel spreadsheet on a shared drive at work. When people in
> the office open the file, is there a way to make them "save as" and
> not to be able to type on the original file?
> Th...Accidently "SAVED AS"!! Help!
Is there any way to recover/restore an excel file once it has been "SAVED AS" once it has been overwritten
"Nicky" <firstname.lastname@example.org> wrote...
>Is there any way to recover/restore an excel file once it has been
>"SAVED AS" once it has been overwritten?
Only if you have a backup. If you don't have a backup, not possible. This is
why backups are essential.
If the file was saved as a new name, the original will still be on your
If it was saved as the same name, it has been over-written and unless y...Text want wrap in text box
I can't get the text to wrap in a text box, word wrap is set to true, I put
some text boxes on a sheet today and the text will not wrap, I did this
yesterday and it worked fine, I can copy the ones from yesterday and paste
them on a new sheet and they work, any ideas? I have rebooted but this did
not help. Using Excel 2000 (9.0.6926 SP3) Thanks Paul B
If you're referring to a Control Toolbat text box make sure that the
MultiLine property is True.
"Paul B" <email@example.com> wrote in message
news:%23ovLUkuLEHA.2456@TK2MSFTNGP12.phx.gbl......Need query of all records based on month
How can i create a parameter query in the query grid to ask for all records
based on the month. example: i want all records for May 2007. any ideas?
In article <21EC5C38-AB39-4AA1-88D8-7C9627A947FE@microsoft.com>,
> How can i create a parameter query in the query grid to ask for all records
> based on the month. example: i want all records for May 2007. any ideas?
say you have a date column in your table
Criteria: DatePart("m",[Enter date:])
In article <21EC5C38-AB3...Saving Large Files
I am saving a large Publisher file and recieve the error "Cannot save file -
delete some objects", Is there a file size limitation for a publisher file??
Publisher 2000 has a 2 gigabyte limit. Do this, view, pictures, turn off
detailed display. Delete some of your temp items. Type %temp% in the address bar
in Windows Explorer.
Mary Sauer MSFT MVP
"Large Publisher Files" <Large Publisher Files@discussions.microsoft.com> wrote
in message news:F7C65EA5-3D53-46CB-9C4A-A2DB8333FB91...Opening CSV file(saved in unicode) in excel
If anyone can help me on this, I would really appreciate
I have a file that is saved in .csv extension (Unicode
format). Let's say for example, I have the data as follows:
When I save the above data in .csv (in Ascii format) and
open in excel file, I see that each value is placed in
When I save the same data in .csv (Unicode) I see the
whole information appears in the single cell(first cell
Is there a limitation to the CSV FILE opening in EXCEL,
with Unicode format?
Any inputs/...Want to Add more Sub description Field
How I can add more sub description field like 1,2,3,4,5
You have only limit up to 3 fields in RMS 1,2,3 sub-description also you can
use the extended description and there is main description for the item. so
Altogether you have upto 5 description limit and I think that is enough. Let
me know if this won't fulfill your requirements else use the Item Notes for
Rate if like
"Saleem Suri" wrote:
> How I can add more sub description field like 1,2,3,4,5
> Saleem Suri
...Saving configurations in Word 2007
I have 800 word users that get mad everytime we update their word2007client
and all indvidual configurations (don´t show spelling and grammatics, don´t
show changes and so on) just vanish and is replaced by default. Any solution
of this problem?
How are you updating them?
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><&...Help with duplicate fields
Supose I have a Products table with code and description fields:
In this particular case, duplicate codes are not a problem since the
code is not a primary key,and similar items stocked at various
facilities will have the same code, with another field being used to
determine the specific stock item's location. So this looks more like
the actual table:
code loc description
---- --- -----------
001 A hamburger
002 A cheesburger
003 A hotdog
001 B hamburger
002 B cheesburg..."Save as" box in MSWord
For some odd reason I cannot save a (new) file in MSWord because the "save
as" frame is larger than the screen size on my notebook. Because of this, the
space for the "File name" and "Save as Type" panels - and the "Save" or
"Cancel" boxes cannot be reached. When trying to push the frame higher on the
page so that I can access and enter data into those panels and boxes, it will
move only for as long as I "hold" it in place. As soon as I release the moved
frame, ready to enter data into the panels and boxes, it slips ...deleting a record after copying data
I currently have code in a form called workorders to execute after update to
copy data over to a new form called Closed_Workorders. using two different
tables (tasks and closed tasks) How do
I write the code to delete the record once it is copied.
"Thanks for your Support"
Here is the code:
Private Sub Status_AfterUpdate()
If Status = "Completed" Then
Dim StDocName As String
Dim StDocnbr As String
StDocName = "Completed_WorkOrders"
StDocnbr = [Log_Number]
DoCmd.GoToRecord , , acNewRec
Forms![Completed_WorkOrders]...PM check numbering
Other than the user overriding the check number for a payables check run, is
there a reason why a check number might be skipped?
When you go to enter a Manual Payment transaction, the default Payment
Method is Check...if someone is recording a wire payment, but doesn't change
the Document Number or the Payment Method, then the next available check
number is used by this transaction even though you have not printed a check.
Similarly, when you enter a Bank Transaction, the default Type is Check and
if you don't change that or the Number, this transaction will u...I want to add a sound event when the cursor bumps left margin
I want to know (via an event sound) that my cursor movement has bumped the
left edge of the spreadsheet. I am entering thousand of rows of data, and it
would help if there was a event sound when I returned the cursor to the left
edge. I have this feature in 123, and find it helpfull.
Put this in the sheet module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static ColOld As Integer
If Target.Column = 1 And ColOld > 1 Then Beep
ColOld = Target.Column
mvpearl omitthisword at verizon period net
"m...columns misaligned after save
I open a spreadsheet from a network drive, make my required changes, save the
document, and exit.
When my supervisor opens the spreadsheet, the columns are misaligned i.e.
the first few columns have moved down by 3 cells.
I only work with rows, entering data into exisitng rows. I do not do any
cut-and-paste operations that might normally affect column alignment.
Thanks for any help offered.
Just some questions...
Are you sure you and your supervisor are viewing the same workbook?
If you are positive (I'd double check), do you have any macros that run in this
MarkJames...two page numbers per "page."
Operating System: Mac OS X 10.5 (Leopard)
I would like to make a book pages... like a novel: One sheet of paper, sideways, with two columns of text (and TWO PAGE NUMBERS). You fold the pages over to make it book size. <br><br>I haven't been able to make the two columns each have a separate page number (except typing each one in). Thought maybe "Sections" but couldn't make it work. Looking for suggestions. Thanks.
it would be possible to do so with section breaks, but it would be extremely
tedious, as you woul...How can I save a publisher file in a format that can be emailed.
I produce a small newsletter in Publisher. I would like to be able to save
it in a format that can be emailed, not as a publisher file, which takes too
long to download.
>I produce a small newsletter in Publisher. I would like
> to be able to save it in a format that can be emailed,
> not as a publisher file, which takes too long to download.
Download and install the following free PDF Creator.
With your new program installed...open your project
in Publisher and go to...File / Print.
On your Pri...