A document with the name "abs.xls" is already open.
I need assistance. Everyone workbook I open in Excel 2000
keeps giving me the message "A document with the '___.xls'
is already open. You cannot have two workbooks with the
same name open even if they are in different files. etc"
The name of the document in the message is always the
workbook I have just opened. I've tried shutting down and
rebooting, and that did not work. This started to happen
after I copied a workbook off my company network to my C:
drive. Can anyone help? I can't seem to get rid of this
Maybe this from from Debra Dalgleis...Loosing some colors when copy/pasting from/to Visio
I have seen the following problem numerous times:
Problem: I create a Visio diagram and when I copy/paste the diagram
into another MS Office product, like Word, Powerpoint, or Excel, I
loose some of the colors.n
In fact, I just ran into this when copying a visio drawing from one
Visio file to another Visio file. Note that copying from one page
to another page within the same Visio file did not loose the colors.
Some quesitons I have are:
(Q) Why does this happen and what I can do (if anything) to prevent it
(Q) How does visio, powerpoint, or word stores th...Microsoft is a bunch of crooks and imbeciles, burned my copy of xp
Microsoft is a bunch of crooks and imbeciles, burned my copy of xp.
After spending a whole Saturday afternoon re-installing Xp, because it no
longer worked, losing all previously installed programs and drivers in the process,
because it would hang in install in some unknown place, had to start on a clean disk,
and finally got it working with internet access,
when I started it again today, a week or so later, it decided that my Logitech mouse
was a 'MS mouse', and the cursor jumped all over the screen.
I would like to hit Bill Gates and Balmer in the face for makin...Extra copy of MS Money Plus Deluxe available 04-01-10
Knowing that Microsoft was going to stop selling Money I bought 2 copies for
my 2 computers. I had forgotten that you can install one copy on 2 different
computers so I find myself with an unused copy. I paid $39.99 and am going
to post it on eBay but figured I'd list it here first as a number of people
have said their copy was expiring. If you're interested please contact me
(garbanzo99 at gmail). I have the unused product key good for installation
on up to 2 computers. If your copy is or will expire I can supply you with
the key. If you need the program file I hav...synchiing two computers?
Is there a way to synch Outlook on two computers?
I end up with some email on my laptop and some on my desktop - it would be
nice if the two could be synched so that I could have all of my email on
Take a look here, it may help:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Bill Andersen asked:
| Is there a way to synch Outlook on two computers?
| I end up with some...Outlook 2002-can't open pst
Cannot open outlook 2002 archived =.pst files.They
exist,but Outlook won't display any information when
opened from "file/open/personal folders". There is only a
blank screen. Help?
>Cannot open outlook 2002 archived =.pst files.They
>exist,but Outlook won't display any information when
>opened from "file/open/personal folders". There is only
>blank screen. Help?
Try running the Inbox Repair Tool against each of your .PST files to see if
it finds any errors. Search your drive for a ...Compare two cells in two different files and return answer
I am attempting to compare two text cells and if they both exist, I want to
bring in a "yes" answer. If they don't, bring in a "no" answer. Here's an
example of text.
Col A Col B
Col A Col B
So, what I want to do is say in File 1 take cells A1 and B1 compare them to
File 2 and search Col A and Col B and if there is an exact mat...Project 2007 04-11-10
I am trying to print a budget report, for some reason it continues to sort by
ID even though I have specified to sort by wbs, the wbs column is not even
showing up. How do I get rid of the ID column in the report print preview and
sort the tasks by wbs?
Not sure how you're asking it to sort, but here's what works for me:
1) Select the report, then Edit. Go to the sort tab, then choose WBS in the
Sort By options. If that doesn't work for you, let me know.
2) You'll note in the Definition Tab of the Report that it is being pulled
from the Cost table. Simple a...Pivot table for two different data variables
I have the following table
Name type Cost overhead
amy C1 23 12
bob C2 129 17
cat C2 36 45
doo C2 100 32
I owuld like to create a pivot table that looks similar to:
the standard pivot table. (Please ignore type for now.)
name Data Total
amy Sum of overhead 200
Sum of cost 12
bob Sum of overhead 130
Sum of cost 23
cat Sum of overhead 90
Sum of cost 19
doo Sum of overhead 87
Sum of cost 34
Total Sum of overhead 507
Total Sum of cost 88
But with overall total (overhead + cost) for ...Exchange 2007 SCL rating
I have setup a quarantine mailbox, and configured all the content filters.
Eveything seems to be working, but when i look at the SCL rating on a
quarantined email in the quarantined inbox the SCL rating is -1. This cant be
correct, because emails with an SCL rating that =7 get quarantined, so it
appears that i cam not seing the real SCL rating on the email. how can i
expose this ? i know i can look at the headers of the eamil but uit says -1
not 7 as it should
SCL rating of -1 is assigned to authenticated senders, as also senders on
Safe Sender lists, from IP addresses on IP ...COUNTIF (?) on two criteria
I have a spreadsheet that logs work activities and records team
members' completion of project units.
Column B records team member names. Column C has project unit status -
'pending', 'beta' or 'completed'.
It's easy to set up a formula to count how many units are allocated to
each team member - =COUNTIF(B1:B1000,"Joe"). But what I need to do is
set up formulas to count how many units Joe has completed, or has
pending or at beta, and this means assessing data in both columns -
which COUNTIF won't do.
This doesn't strike me as an especially...How do I keep chart/data link when copying worksheet
I have a worksheet for each month within a file - each worksheet has data
tables, and some charts generated from that data. With Excel 2003, when I
copied a worksheet within the same file (for example, to create the July
sheet, by copying the June sheet) the charts in the new (copied) July sheet
correctly linked to the July data. When I do the same in Excel 2007, the
charts in the July sheet link back to the June data instead. I have looked
through the options and cannot see how to do this.
Is the data on the same sheet as the chart? In 2003, if the chart was on a
different worksheet, ...outlook 2007
I have just upgraded to windows 7 so therefore I have lost windows mail. I do
not want to use windows live mail if I were to buy outlook 2007 would this
work ok as I have only Microsoft home & student installed on my PC
"borderknight" <firstname.lastname@example.org> wrote in message
> I have just upgraded to windows 7 so therefore I have lost windows mail. I
> not want to use windows live mail if I were to buy outlook 2007 would this
> work ok as I have only Microsoft home &a...Can't find "Password to open" box in Excel 2000
I need to put a password on a workbook to stop
unauthorized access but can't find "Password to open" box
in to tools->options->general dialog box
That's because it's not in Tools/Options/General in the
Excel menu. You need to select File/Save As, then click
Tools, General Options in the save as dialog.
>I need to put a password on a workbook to stop
>unauthorized access but can't find "Password to open" box
>in to tools->options->general dialog box
...Two IF Statements with two answers
In cell J9 I need a formula that would do the following:
If G9="Yes" then F9, If G9="No" then -f9
Note: G9 has a drop down list with Yes, No answers.
If there are no other alternatives that yes and no
> In cell J9 I need a formula that would do the following:
> If G9="Yes" then F9, If G9="No" then -f9
> Note: G9 has a drop down list with Yes, No answers.
Positioning the Vertical axes:
I have a chart where there are two axes. The first implementation produced
the two scales on the right side, one inside, the other outside the chart
area. Unusual, but luckily it fits well the chart.
I tried to duplicate the feat with another dataset (similar in structure)
and did not even get the second scale to show right, left or center (data
plotted with two different scales allright).
Where is the info to control these functionalities?
On Wed, 29 Oct 2003 17:48:13 +0100, pl.carry <email@example.com> wrote=
> Positioning the Vertic...Copy Word Text into Excell
I have an Excell workbook that other individuals access and they need to put
a response at the bottom. However, when they attempt to copy their response
from a word document, it either won't accept it as the cells aren't the same,
or it continuously goes across the page. I tried merging cells, but that
didn't work. How can I accomplish this?
One thing that may simplify the data entered is to use the Edit->Paste
Special menu, and select "Text". That won't warranty that the data will be
in the right cells, but at least the format...Outlook 2003 will not open Mailbox
We have a problem with SBS 2000. Clients with Outlook 2002 or older can open
their mailboxes. Clients with Outlook 2003 get the error "Unable to open your
default e-mail folders. The Microsoft Exchange Server computer is not
available. Eithe there are network problems or the Microsoft Exchange Server
comptuer is down for maintenance." Everything was working on the server until
it got a virus. Here is what has been done. The virus was cleaned. SBS 2000
was repaired. Exchange part of SBS 2000 has been reloaded. All clients can
use Web Mail to access their mailboxes with no probl...Draging to copy cells
I have some cells that are like this;
Is there a way that I can drag the cell to continue
changing the time stamp without changing the date?
Thanks for any suggestions.
Right-click on the fill handle (bottom left-hand corner of
cell), and while holding the mouse button, drag down.
Select "Copy Cells" in the pop-up window.
>I have some cells that are like this;
> 02/08/2004 07:01
>Is there a way that I can drag the cell to continue
>changing the time stamp without changing ...Cannot create folders then advised they exist (but I can't see them) in Outlook 2007
I am having huge problems creating new folders in Outlook 2007..
I try to add the folder as normal, then receive the message "Cannot
create the folder. The operation failed. An object cannot be found",
so I try again and it says "Cannot create the folder. The server says
"Mailbox Exists". However the folder I have tried to add does not
display in the Outlook folders list.
So have gone to IMAP folders and completed a search on subscribed
folders to see the folder I had tried to add is featured, but does not
have an envelope next to it (I assume indicating i...where did the tools menu go for excell 2007?
I cannot find the tools menu for excell 2007.
There is no Tools menu in Excel 2007. All of those commands have been
See if this helps:
Microsoft Excel MVP
"Terry" <Terry@discussions.microsoft.com> wrote in message
>I cannot find the tools menu for excell 2007.
Many of the commands are under File (Office Button), Excel Options ...
"Terry" <Terry@discussions.microsoft.com> wrote ...plot two groups of numbers on one series of xy coordinates.
how to create a plot from separate x and y values. i.e. y values do not
correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15
I can read your question 2 ways;
A) you data looks like this
Select the data and make an XY chart
B) you have two sets of data
Make an XY chart of the first data series
Select all the data (including headers) for second set, and use Copy
Click the chart to activate it
Use Edit | Paste Special .... indicate New Ser...Cannot copy selected cells
If I open a new workbook , copy or add text into multiple cells and then do
a Shift to highlight the block of cells the flashing lines around the cells
dissapear and I don't have enough time to do a Ctrl C to copy them!
It doesn't matter if it is new text, copied text from email or another
workbook. If I send that workbook to a colleague he can do it no bother?
The flashing lines show up after you do the Ctrl C to copy. What do you
mean you don't have time to Ctrl C?
>...Opening attachements from emails in outlook express
Outlook express is blocking access to all attachements on
my emails even those that I know are 100% bona fide. I
get the message "OE removed access to the following
unsafe attachments" next to the paperclip icon. I only
set this up to receive my emails recently so may have
made a mistake in the set up. Any ideas??? Thanks David
"David Deal" <firstname.lastname@example.org> wrote in message
> Outlook express is blocking access to all attachements on
> my emails even those that I know are 100% bo...two variables
I have a query that asks for collcode, collcode2 and booth. On any given day
an employee may be collcode or collcode2. I would like to know how many
times a certain emp has been paired with another employee. So how do I ask
if an employee has been collcode/collcode2 and who the other person was? I
hope this question makes sense.
Thanks for any help
SELECT CollCode, CollCode2, Booth
SELECT CollCode2, CollCode, Booth
SELECT CollCode, CollCode2, Count(CollCode) AS TIMESPAIRED
GROUP BY CollCode, CollCode2