2007 Structured Reference auto-completion not working completely?
In Excel 2007, when I:
1) Select a cell
2) Type "=" in the formula bar
3) Click a cell in a Table
I thought Excel would add a Structured Reference to the formula. Instead, it
just inserts an old-style, "A1" reference. The "Formula AutoComplete" and
"Use table names in formulas" options are both turned on. When I click the
cell in step 3, the TableTools tab appears so Excel agrees that the cell is
in a Table. Isn't Excel supposed to insert a Structured Reference when you
click a cell in a Table? Is there another setup/configuration switc...Outlook 2007 Searching
Each time I do an Outlook 2007 search "Tools/Instant Search/Advanced Find" I
have to press the Browse button and check the "Search Subfolders" box.
How do I default to always have the "Search Subfolders" checked?
On Mar 7, 9:44 am, "Jeff Roe" <jdru...@hotmail.com> wrote:
> Each time I do anOutlook2007 search "Tools/Instant Search/Advanced Find" I
> have to press the Browse button and check the "SearchSubfolders" box.
> How do Idefaultto always have the "SearchSubfolders" checked?
I c...Deleted contact in Outlook 2007
I have a new Dell laptop with the #$@#$$%$ touchpad. It's been a week
and I am still dragging stuff I don't want to drag and selecting stuff
I don't want to select. AAARRRRRRGGGGGGG.
Anyway, I had a contact open in Outlook 2007 and I did something with
the touchpad and the contact disappeared. I don't know if I deleted
it, renamed it, hid it, or what.
Would I be able to delete it with just one errant touchpad action?
Wouldn't it ask me to confirm it?
I tried Ctrl-Z but Edit | Undo is greyed out. Will Undo undo a deleted
If I didn't delete it, where could i...Task Manager and unsecapp.exe
When running Task Manager I recently found unsecapp.exe running.
I am using XP Pro and have never has Vista on my machine, can I stop
It has used 26840K of memory.
On 11/25/2009 9:20 AM, Bill T wrote:
> When running Task Manager I recently found unsecapp.exe running.
> I am using XP Pro and have never has Vista on my machine, can I stop
> this program?
Have you tried using Google to search for "unsecapp.exe" to see what
you'd find? I just did and the first 4 sites listed were enough to
satisfy my curiosity.
R...Outlook 2007 cached mode problem
I do some support for a small company that has just installed their first
seat of office 2007. They are running SBS 2000. When Outlook 2007 is set in
cached mode no emails after February 7th show for the user and no new emails
If cached mode in turned off all their emails show. They were running
Outlook 2002 on another machine previously which doesn't have cached mode so
without trying it on 2003 I can't tell if it is a server or client problem.
All other folders appear to be OK.
Any suggestions? Has anyone else had this problem?
I support this site remotely so exh...Calculate cost of project against time worked
Have had a good look through various discussion groups for this and can't
seem to find what I am looking for, I hope someone can help.
I have a access 2000 database which captures projects coming into the
department, each project is then resourced to a team member. When they have
finished their part they put in how long it has taken them, from 1 hour (up
to max of 3hours) then it goes up in 1/2 day increments to 15 days.
At the moment I just have a drop downlist allowing them to pick, for example,
1/2 day, 1 day, 1.5 days etc, but now we have a set daily and hourly rate for...word 97 covert to word 2007
old saved word doc. wont run in word 2003-2007
Files with insert pics okey.
Some files will convert but 100 or so will show but not open
Have tried many solutions , inc. repair Office
Have you tried to repair the *documents* by using Open and Repair in Word 2007?
Microsoft Word MVP
> old saved word doc. wont run in word 2003-2007
> Files with insert pics okey.
> Some files will convert but 100 or so will show but not open
> Have tried many solutions , inc. repair Office
...completed task triggers new task
Can you set up the task function in Outlook to create a new task once a
"master task" has been completed?
What kind of new task? In the form of a recurring task? You can then
configure the Recurrence Pattern on the task.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"Sherri" <Sherri@discussions.microsoft.com> wrote in message
news:DED33B01-1A25-4181-B062-FD416472C589@microsoft....Powerpoint 2007 01-14-10
Any chance you know how to REVERSE the order of the bullets (in the old
version you could go 10 – 1)
...Ahead of Schedule task and % complete
If I enter a % complete value on a task that indicates it's ahead of
schedule, how do I get MS Project to reflect an earlier finish time than
Here's a quick scenario:
Let's assume I'm on a 2-week project with one task and one resource.
Project starts on the first Monday and ends on the 2nd Friday. At the
end of the first week, I enter a status date of Saturday into Project
Information and a % complete of 80% on the task. Theoretically my
project is 3 days ahead of schedule. Is there any way I can get MS
Project to reflect that via levelin...Outlook 2007 appointment durations
Is there any way that we can change the default duration of an appointment
from 30 mins to 20 mins.
"Michelle" <Michelle@discussions.microsoft.com> wrote in message
> Is there any way that we can change the default duration of an appointment
> from 30 mins to 20 mins.
Set your calendar time scale to ten minutes (right-click an empty area of the
calendar, choose Other Settings, and change the Time Scale drop-down), then
preselect two time intervals before clicking New. Wi...Changing default indents for lists (Word 2007)
In previous versions of Word this was relatively easy. I'm pretty adept with
Office products, but as far as I can see this is no longer possible. Can
someone confirm or enlighten me?
I don't like the indents that Word 2007 imposes on bulleted and numbered
lists -- it wastes a lt of space and for me is difficult to visually scan. I
prefer my first levels of bullets (or numbers) to appear so that the bullet
is lined up with the left margin with a hanging indent of 0.25". Then I like
the second level of bullets to be at 0.25" with a hanging indent of 0.5",
...Timesheet and Employee Expenses Approval by Project
I would like to suggest the approval workflow to be by project, right now in
project accounting, the employee only can have 2 level of approval, ie,
Supervisor and Manager, at most of my client that using Project Accounting,
they are requesting the approval to be go by project, ie for the same
employee that doing different project, their respective timesheet and
employee expenses should route to the supervisor or manger that assigned to
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this ...MS POS 2.0 and Office Account 2007
Has the integration been improved between these two applications since the
SBA 2006 and POS 1.x were released?
When I looked at it back it didnt do transactions, just batches. I am
looking for full integration between the two products.
Point of Sale 2.0 ships with Office Accounting 2007 for free. There is a
very tight integration where detailed sales, item, customer, vendor, and
item receipt information is shared automatically. This site has more info:
"DomitianX" <DomitianX@discussions.microsoft.com> wrote in message
news:C6E30AA5-8D21-431...Selecting multiple criteria in a report in Acc 2007 using a form
How can I select multiple criteria using a form to generate a report in
On Wed, 10 Mar 2010 17:38:04 -0800, Lady_Dee
>How can I select multiple criteria using a form to generate a report in
By putting multiple instances of
or other appropriate expressions on the Criteria line of a query, and use that
query as the Recordsource for the report.
For a more detailed answer please post a more detailed question.
John W. Vins...My Word 2007 Crashed Whenever I Open It 03-14-10
Whenever I open Word or click on a word file, the Word GUI opens and
immediately stops responding. The file doesn't load, and none of the buttons
can be pressed - I just see a word window without a document and toolbars
which can't be pressed. What should I do in order to begin troubleshooting?
See the article "Problems opening Word” at:
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, ...Reset of PO, SO sequence numbers
GP 9, SP2, SQL Version.
On separate occaisions, our P/O numbering sequence has been reset (to a
lower number) as well as the S/O numbering sequence.
Has anyone seen this before and know the cause?
It just happened to us last week, too (and has before). I don't know what
"Ken D" wrote:
> GP 9, SP2, SQL Version.
> On separate occaisions, our P/O numbering sequence has been reset (to a
> lower number) as well as the S/O numbering sequence.
> Has anyone seen this before and know the cause?
For PO's, the only reas...macro for repeat task and format interior
I'm trying to check out repeated value on column Q and the hightlighted
entire cell on the left.I put the code that found from Sample,and trying
to modified it but I made a mistake.I can't select entire cell on the left,
I just can highlight 2 cell ( offset(0.-3) and the cell on column A).Please
help how to select entire cell to the left without interupted by blank cell.
And also I want to put the copy of higlighted cell value to a new workbook.
Dim eX As Integer
Dim cell_in_loop As Range
eX = ActiveSheet....Auto Fill function in Excel 2007 not working properly
I cannot get the Auto Fill function to increase values in a series, and I
feel certain I'm doing it right:
First, I tried typing a series of values in a column like this: Cell A1, I
typed 1. Cell B1, I typed 2. Then, I selected both cells with the mouse, and
then moved to the lower right corner of Cell B1 and left-clicked and held the
mouse button down. Then I dragged the mouse button down several columns. The
little pop-up message seemed to indicate that it was repeating 1, 2, 1, 2.
When I released the mouse button, it had actually filled a 1 in each cell!
After several ...DPM 2007 SP1 and Windows Server 2008 SP2 Hyper-V Failover Cluster
Should DPM 2007 SP1 be able to backup virtual machines that are in a Windows
Server 2008 SP2 Hyper-V fail over cluster?
Each VM has a dedicated LUN at this point in time.
From previous experience the backups appear to be inconsistent from the
stand point of if the machine is migrated to another host the backup breaks.
Has anyone successfully implemented backups for this type of environment?
DPM 2007 SP1 does officially support backing up VMs on Windows 2008 SP2
This posting is provided "AS IS" with no warranties, and confer...Default Weight in Pivot Table Charts keeps getting reset
I have created a Pivot Table chart and I am using basic line chart to
display the data...I would like to make the line weight 2 points heavier than
the standard but each time I select new values from the Pivot Table chart it
resets to the default....where do you set this to remain at the values
Any help appreciated....
...integration of project server 2007 and moss 2007
I have two server in one i have installed single server installation of
project server 2007 in which and on the other server separately i installed
moss 2007 and make Database server of MOSS 2007 is Project Server 2007.
Now we can integrate Project Server 2007 and MOSS 2007 in this way and want
to configure proposal workflow.
Because i dont want to install moss 2007 in existing installation of project
I don't know Project Server, but your question is not clear as to what you
Daniel A. Galant
Imagine what we could be... if we co...Printing Monthly Calendar (Outlook 2007)
My work has upgraded from Outlook 2003 to Outlook 2007. Every month I print
off the monthly view so I can monitor regular events.
Outlook 2003 monthly print option only displayed the current month (5
weeks). In Outlook 2007 I am getting a six week view which is compressing the
meeting information and displaying some of the next month. Is there a way I
can set this so I only get the current month ?
Do you have all the latest updates installed? Outlook 2007 should print
exactly 1 month - but there was a bug in early builds and it always did 6
Diane P...Weird message when opening Word 2007
Since upgrading to Windows 7, I'm getting a strange message when I open Word
2007, which I never got using previous Windows versions. It says: Word could
not create the work file. Check the temp environment variable. When I click
the OK button, Word opens up and there does not seem to be any problems, but
I'd like to get rid of these messages. How can I do that?
When Word starts it needs to create a raft of temporary files - some in the
working folder, others in the User's temporary folder. The message suggests
that Word cannot locate the temporary folder or that it c...Outlook 2007 won't open
Sometimes I close Outlook 2007 when I'm working during the day and then when
I try to open it it won't open. The other MS applications in the 2007 suite
open OK all the time. It is only Outlook that does this - maybe 2 or 3
times a day. I have to re-boot to gain access to it again.
If, after trying to launch Outlook 2007 I do a restart, the application
opens momentarily before Windows logs off and the computer restarts.
Maybe OL isnt exiting correctly, and as such your Processes Tab will show an
instance of Outlook.exe still running
(Cntr+Alt+Del > ...