Document Properties in header / footer without VBA
I was looking for way to insert document properties, also maybe custom
doc properties into the header or footer of Excel WITHOUT the usage of
e.g. something like if you would like to insert the date &[date] I
would like to use &[Author] but excel doesnt accept stuff like this.
is there a way?! somehow.
thanks a lot
not possible without VBA. So no way to do this witout macros
hans werner wrote:
> I was looking for way to insert document properties, also maybe
> doc properties into ...Re: Update for Windows Vista (KB980248) -- No more fonts available!
PA Bear [MS MVP] wrote:
> Are you running Vista SP1 or Vista SP2? Is Office 2010 installed?
> Was KB980248 offered & eventually installed via Windows Update or did you
> (attempt to) install it manually?
> What anti-virus application or security suite is installed and is your
> subscription current? What anti-spyware applications (other than
> What third-party firewall (if any)?
> Has a(another) Norton or McAfee ap...Not allow entering repeated references in a column
If you don�t mind ... I will send it :) .
As I don�t know your e-mail, I will give mine, which is
Just send your e-mail to my e-mail box and I will send the file.
ritinha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1566
View this thread: http://www.excelforum.com/showthread.php?threadid=27195
...changing the cell information #2
Hi I have files I tried to change the cell information to another cel
that have to be the blank for a row that contains director name in cel
A and for the movie titles I have to have director names instead of th
title names.Please help me, the data in cell B sholuld have to be,
2 T:Back to the future
5 D:Adam Mathew
6 D:Adam Mathew
7 D:Adam Mathew
Message posted from http://www.ExcelForum.com
...Incorrect Office Updates in Microsoft Update
I recently did clean installs of XP and Win7 on 2 different PCs. Each PC
was loaded with Office 2007. When I ran Microsoft Update after the Office
installs, it shows I needed Office 2007 SP1, not SP2. I manually downloaded
and installed Office 2007 SP2 and then checked Windows Updates for any
needed patches. It still showed I needed Office 2007 SP1...even though I
just installed SP2.
Does anyone know how to 1) have Office SP2 show up as a needed update
instead of SP1, and 2) how to configure Windows Update to show that no SP is
needed after SP2 is installed?
Everytime I boot up my PC a small window pops up entitled "UPDATE MANAGER".
It shows two progress bars, but nothing ever happens. Why is this window
popping up every tiem I turn on the computer and how do I get it to stop?
It never used to do this, it just statred lately. Thankyou.
Because you installed something which features an update manager
"Omaha Tony" <OmahaTony@discussions.microsoft.com> wrote in message
> Everytime I boot up my PC a small window pops up entitled "UP...catching enter key for multiple editboxes
I know that to catch the enter key I need to subclass the editbox control,
but I was wondering if there is a way to do this for multiple editboxes
other than to subclass each control? I suppose I could do one and then
create the others dynamically, but can it be done during design as well?
...automatic office updates
Is there a way to configure a PC to receive Office Updates automatically
like Windows Update?
Via MicrosoftUpdate as apposed to windowsupdate, and then configuring how
you update. eg automatic or download and notify
"J Miller" <jmiller@*nospam*pcsdps.org> wrote in message
> Is there a way to configure a PC to receive Office Updates automatically
> like Windows Update?
Yes. Microsoft updates does this. What version of Office do you use?
Diane...does vista installed on virtual machine 2007 get wsus updates ?
It is searching for updates but it is not finding anything and saying
that Windows is up to date. I have set the updates to install from the
wsus server and assigned the updates to the same Vista virtual machine
aconti's Profile: http://forums.techarena.in/members/73272.htm
View this thread: http://forums.techarena.in/active-directory/1290161.htm
If the machine is getting the correct GPO for the WSUS settings, check with
rsop...Outlook 2000 doesn't respond after downloading MS update!!
Luckily, my Outlook Express seems to work, but my Outlook 2000 will open,
but if I click on a message or do Anything, it FREEZES.
HELP!! I rely on calendar functions, other things.
HOW could MS allow an update that screws up their own programs?
I did restore - to no avail. I lent CD to someone, so can't do "repair."
(Trying to get a hold of friend)
Please help! I'm in process of job hunt & really need Outlook to
Did you recently apply SP3 for Office/Outlook 2000 and is Outlook 2000
configured in Internet Mail Only mode? If yes, you...Unable to enter correct product key
I have purchased a Mac G4 PowerBook and installed my Microsoft Office
(student and teacher edition). Not understanding the significance of
the Product Key, I entered a code that I have already used on another
computer. Now I am unable to open Microsoft Word on my hew computer
because I also have the same product key used on my old computer. I
have three product keys. How can I install the program in my new
computer using the correct product key?
In article <firstname.lastname@example.org>,
email@example.com (george) wrote:
> I have purchased a Mac G4 PowerBook ...Can you separate information by House?
I have two homes and want to track expenses for each home separately as well
as roll up reports by category (utility, phone, etc.) for both. Is that
In microsoft.public.money, MT wrote:
>I have two homes and want to track expenses for each home separately as well
>as roll up reports by category (utility, phone, etc.) for both. Is that
One way to do that is to use a classification.
As Cal notes, Classification is tailor-made for this. Look it up in online
help and then come back with questions.
"MT" <MT@discussions.microsoft.com> wrot...can't update office xp
I can't download the latest updates for office xp. I get
a "hotfix" error. I also can't have microsoft check my
computer for installed updates. it just tells me that my
computer is unable to communicate with microsoft.
>I can't download the latest updates for office xp. I get
>a "hotfix" error. I also can't have microsoft check my
>computer for installed updates. it just tells me that my
>computer is unable to communicate with microsoft.
>guess no one has any reply to this, should I reload
outloo...What exactly is office, excel, and encarta?
Office is a collection of programs including Excel, Word,
Outlook, PowerPoint, and Access. Excel is a spreadsheet program
that is included in the Office collection. Encarta is an
encyclopedia, dictionary, and thesaurus.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Samantha" <Samantha@discussions.microsoft.com> wrote in message
...Need help with update sql plus filter
I have the following update sql (copied from the query design view)
UPDATE ListQry SET ListQry.ApprovalStatusID =
And (ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID)>300)) OR
(ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID) Is Null));
ApprovalStatusID is an integer
OtherStatusID is an integer
ListQry is the recordsource for my form. I would like to add the f...CRMADDIN adjustments.
Is there a way to change where the CRM toolbar displays when a new message is
located? I have checked for available COM Add-In Registry keys and can not
find any that would allow us to right justify the tool bar. I would really
like to move the toolbar off the left hand side of the window so that it is
not located directly under the “Send” button in Outlook.
There is no control over this
Microsoft CRM MVP
"Redadmin" <Redadmin@discussions.microsoft.com> wrote in message
news:CDE407...collating information from multiple sources
Apologies if this has been asked before, but I'm a bit of a newbie when
it comes to mucking around in excel, I've had a search but I don't
really know what to call what I want to do, so finding the answer is
Anyway. I have a dozen or so workbooks that are all of the same
format, 1 work sheet with a basic list of test scenarios in each, with
a unique reference for each row.
What I'd like to do is pull information from all those workbooks into a
separate workbook by the use of the unique reference. i.e If I type
in the unique reference in the master workb...Excel link update question
I need to maintain an excel workbook which contains a lot of links to
workbooks. Since the linked workbooks change every week, I need to
the links accordingly. For example, a cell with formula
!A10" will be changed into "='[sep_4.xls]sheet1'!A10". I tried to do
Find/Replace. However, the link is updated every time it is changed.
The link updating takes a couple of seconds. So it may take a hour
to finsh it for a workbook with thousands of links. Could anyone tell
to shut down the link updating when...Update Query
Access 2003 XP SP2
I am having a problem with an update query.
Table is in a one-to-one relationship, referentail integrity and
cascading data are checked.
(The fileds I want to update are not in both tables)
Table name= payForward
Has 15 fields ie: ID, Name, MemID, Oct , Nov, Dec, etc
Oct-Sep fields are yes/no type
I want to "select" a field (Oct-Sep) via a query parameter and
repalce "yes" with "no".
Here is my query:
UPDATE payForward SET [Enter month]=No
The messages I get is
'operation must use an updateable query'
Wh...can not mount information store
i am receiving event id 454, Information Store (2704) Database
recovery/restore failed with unexpected error -540. . in exchange admin i get
the error An internal processing error has occurred. Try restarting the
Exchange System Manager or the Microsoft Exchange Information Store service,
we have plently of disk space available which is stated as the cause by a
number of tech notes.
Can anyone help?
Did it happen after restore?
Try to move the exchange log files (cut-paste) and mount the store.
If still can’t mount run eseutil.exe /p
"nick reed" wrote...SP 1 & 2 Updates
I noticed that when I installed the SP 1 & 2 Updates, I
could no longer get .zip, .doc, .htm, .exe attachments
and anything like that (.jpg and .gif are no problem). Is
there a way to enable attachments of other types to come
through? I would like to install the Updates, but need to
be able to receive attachments. Thanks for your help.
...tasks entered in taskpad don't appear in task folder
All of the tasks that I have entered via the taskpad do not appear in
the task folder, what am I doing wrong or do I have the wrong
What view are you using on your Tasks folder?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
"John Keith" <firstname.lastname@example.org> wrote in message =
| All of the tasks that I have...How do I lock a chart so it will not update?
That's the question. I have my data in Excel and the chart in Excel but not
all the data cells are used. Everytimg I open the chart it wants to update
and I want it to stay the same.
Any ideas on how to lock the chart?
Just a few ideas:
You could lock the cells that are shown in the chart.
Or you could copy the cells and paste as values (assuming formulas were used
that update when other cells change).
http://www.wimgielis.be = Excel/VBA, soccer and music
"Locking a Chart" wrote:
> That's the question. I have my data in Excel and the chart in ...Microsoft Update 'left behinds'
Every time I download and install the latest Microsoft Update 'fixes' to
XP-Pro, the file space taken up by XP-Pro grows and grows. While this
will be an elementary question to many, is some of this XP-Pro file
space 'growth' being caused by stuff that the 'fixes' leave behind and
files that XP-Pro no longer needs?
If so, can these 'left behind' files be gotten rid of so as to reclaim
some HD space? Are there any pros and cons to deleting these 'left
Assuming that these 'left behind' files can be deleted, what i...HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE
My cell c1 contains the formula b1-a1.when i copy this formula to cells d1
and e1 the cells d1 and e1 have the following formula :
but i want the following
d1 should be b2-a2 and
e2 should be b3-a3
how do i do this?
In C1 enter & copy across:
> My cell c1 contains the formula b1-a1.when i copy this formula to cells d1
> and e1 the cells d1 and e1 have the following formula :
> but i want the following
> d1 should be b2-...