Excel 07 selects 3 cells when I click on 1
Hi I just got 2007 (I want 2000 back) and a lot of the time when click on an
empty cell 2 or more below it are selected and the typing goes on the bottom
row. I just want to select the cell I click on.
Are the cells merged??
I don't like the 2007 either!
If i could i would have the look and feel of 2003 on the engine of
On Thu, 1 Nov 2007 20:21:01 -0700, Brian
>Hi I just got 2007 (I want 2000 back) and a lot of the time when click on an
>empty cell 2 or more below it are selected and the typing goes on the botto...Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu.
Under Look In options
Find allows for search by formulae OR values OR comments
Replace is restricted to formulaes ONLY
Have a look at this google search result. This topic came up a couple days
ago and was addressed by Dave and Myrna.
Gord Dibben Excel MVP
On Fri, 28 Jan 2005 03:49:02 -0800, "cp" <firstname.lastname@example.org> wrote:
>Under Look In options
>Find allows for search by formulae OR values OR comments
>Replace is restricted to formulaes ONLY
...Can anyone send me the Microsoft.Crm.Platform.Proxy.dll and Microsoft.Crm.Platform.Types.dll files ?
I'm stucked without those files, and I don't have the instalation disk.
Can anyone send me those files ?
Thanks in advance,
You can download the program from Microsoft.
email me and i will send them over
Microsoft CRM MVP
"Eddie" <Eddie@discussions.microsoft.com> wrote in message
> I'm stucked without those files...Jon Peltier
How would you do this with a Pivot Table? I'm not a Pivot Table novice and
I just can't envision how this one would be done.
Hi Barb -
I didn't see this question at first, but I responded in the original thread. I
didn't try to replicate the OP's one column setup from his first post, because it
didn't match the more logical arrangement in his post in the other forum.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
Barb Reinhardt wrote:
...how do i enable dde in excel?
i am posting a DDE link into an excel cell from an external program and
getting the message
' DDE Not enabled' in the cell once the link is pasted in.
how do i enable DDE?
...after saving to cd many times. now says read only?
i have saved many times to my cd. i overwrite it almost daily (CD-RW) all of
a sudden it now say's the file is read only. although i can still save to my
> i have saved many times to my cd. i overwrite it almost daily (CD-RW) all of
> a sudden it now say's the file is read only. although i can still save to my
> hard drive?
Unless you have formatted your CDRW for packet writing, then yes, it
will be Read only. CDROM = CD Read Only Memory!
Interim Systems and Management Accounting
Just ...excel file can't be opened #2
I have a recent excel file (about 1 month),but since two days ago,the file
can't be opened completely or always not responding.
What should I do so that I can use this important file.
Any help would be appreciated
...How to transpose in excel file
Hi I would like to make a transpose like this?
House Defect How much
#1 Broken Sinks 1000
#1 Bad Paint 2000
#1 Bad Lighting 1000
#2 Broken Sinks 0
#2 Bad Paint 2000
#2 Bad Lighting 100
and Transpose into
House Broken Sinks Bad Paint Bad Lighting
#1 1000 2000 1000
#2 0 2000 100
A Pivot Table will do that and more.
Set House as row field, Defect as column field and How much as data.
HTH. Best wishes Harald
"vilfood" <vilfood@d...Can't auto-complete e-mail addresses
I just imported about 2000 contacts in my Outlook 2000 Address Book.
Able to see them in the address book and create groups etc.
But when i compose a new message and i try to enter some e-mail
addresses in TO and then why do outlook do not give me suggestion to
I tried most of the settings. It wont work.
What may be the problem?
Outlook 2000 has no such feature. Autocompletion didn't start until Outlook
Versions of Outlook earlier than Outlook 2002 have a feature called
auto-resolution. If you enter part of a name or a nickname then tab out o...Can't restor backup file, "Please insert the next backup disk.....
I have money 2005 backup file (.mbf) and my original file has gotten
corrupted somehow and can't repair it (computer hung and had to be
restarted). Whenever I try to restor the backup file, I get the following
Window Title: Money Multiple Disk Backup
Message: Please insert the next backup disk. (The disk containing file "".)
I was backing up on a different connected single harddrive and there is only
one file. The file is not in multiple pieces and on different drives. When
I click OK, it doesn't do anything and cancel just stops the process.
I even down...How can I shade area under a norm dist graph?
I have graphed a normal distribution curve. =Normdist(x,4,4,false) for x=-8
Now I would like to shade the areas where 8.5<x<12 and x<-3. That
is, the left tail and a portion of the right tail. How do I do that?
For one method, see
- Mike Middleton
Decision Analysis Add-ins for Excel
"TimH" <TimH@discussions.microsoft.com> wrote in message
>I have graphed a normal distribution curve. =No...Headers in Excel #3
Can you tell me if it's possible and if so, how I can
change the header cells, i.e. A B C D E ... etc?
no this is not possible. The best workaround you can achieve is:
- use row 1 as header
- goto cell A2 and to the menu 'Windows - Freeze Panes' to always show
- in 'Tools - Options - view' you can hide the row and column headers
"Andrea" <email@example.com> schrieb im Newsbeitrag
> Can you tell ...portfolio value over time
I run Money 2004 and i can't do some things i think are
really basic - main two (related issues) that bother me
are: 1) is there any way to view the value of my entire
investment portfolio over time (e.g. as a chart showing
basically just price * volume of shares i own for each
investment, combined to show all investments together)?
2) is there any way to view price history for all my
holdings as an indexed value (0% at the start growing up
or down based on % change in price) as opposed to
absolute value? Some shares are $20 each some are $200
each - doesn't make sense to sho...Can't access comcast newsgroups in outlook express 6 or Outlook 2003
I had the comcast news server working in both aps, but trying to make it
work with outlook 2003 as the default program to access the newsgroup
reader, by removing the newsgroup account in outlook express 6, I now can't
get it to connect in either ap. duh...
It's completely gone from Outlook 2003, ie, where before, under the go
button there was a link to news, now there is not.
Outlook express 6 still has the newsgroup reader, that's how I'm sending
this, but when i try to go to the comcast news server it repeatedly asks for
username and password. I deleted the a...determining user-defined chart definition
How can I look at the code/description of a user-defined chart?
...Excel -> Access Import Bizarreness
A guy gave me an Excel file that he needs me to covert to XML. No problem.
Slurp it into a database and use a DataSet.WriteXML() call to turn it into
an XML file.
But I can't import it into Access because it has "Merged Cells". For
example, data that should look like this:
The three "this" cells have been merged into one tall cell:
I need to "unmerge" these, but I know almost nothi...Is this possible within Excel 2000?
Hi, I've used Excel on a get by basis for many years at work, and I'm just
beginning to realise its vast capabilities, having viewed several groups
which I didn't know existed previously.
I subsequently would like to ask if it is possible for Excel to look at the
numerical or text content of a cell on one worksheet and then look at a
predefined range on another worksheet and find the equivalent cell content
and then move the cursor to that cell? This has me stumped presently.
Thanks in advance for any assistance.
To actually move the selection, you'd need to use a litt...Excel 2000 fail to open workbook
I have one Excel template. If we open it on Excel 2000, the Excel will hang,
and the process occupy cpu 95% ~98%.
But we can open this tempalte in Excel 2003 normally, and if we save this
tempalte in Excel 2003, and then open it in Excel 2000, it work normally
Excel 2000 (9.0.3821 SR-1)
Excel 2003 (11.8231.8221) sp3
Would you help us to find the reason for this issue?
Perhaps there was some (probably minor) corruption/inconsistency in the workbook that Excel 2003 could fix but Excel 2000 couldn't.
[Microsoft MVP - Word]
...Not a make item error
I am trying to create a BOM for an item I just created. I set the Item
Replenishment Method to 'Make' on the Item Resource planning screen, but get
an error when trying to create a BOm for this Item. What have I missed?
You have to assign this item as Make item in the Item Engineering window also.
> I am trying to create a BOM for an item I just created. I set the Item
> Replenishment Method to 'Make' on the Item Resource planning screen, but get
> an error when trying to create a BOm for this Item. What have I miss...How can I create an invoicing database in Excel?
I would like to know how to create an invoicing database, or register in Excel.
(Invoice + tax = total) Are there any templates free online?
How about a web search?
search for invoice
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"Vcollins" <Vcollins@discussions.microsoft.com> wrote in message
>I would like to know how to create an invoicing database, or register in
&...can't add transfers to my budget
I have 3 accounts and I want to have 2 budget plans
I want to have one "main" budget that has all my expenses, then another
budget for my girlfriend and I's joint expenses.
We have a joint account.
I wanted to add the transfer from my checking into our joint account in my
"main" budget. I have a group named "Transfers out of budget accounts" but
I can't add anything to it or edit it.
How can I accomplish this? I say one post here: http://umpmfaq.info/faq.txt
that sounded hopeful, but when I tried to follow the instructions, nothing
Is t...HowTo add row to series data
1) insert row with ShiftDown
2) apply new data to the newly emptied cells
3) preserve original chart series range
1) after this code row 2 is empty cells
Excel.Worksheet chart = (Excel.Worksheet)book.Worksheets["Chart Data"];
Excel.Range rngToday = chart.get_Range("A2", "D2");
2) this puts todays date into A2
rngToday.NumberFormat = "MM/dd";
rngToday.Value = DateTime.Today;
3) OOPS - the chart data is now A3..A7 because of the insert above
How do I reset the souce data to A...Excel prints some sheets very small
When I try to print multiple sheets of the same workbook at the same time,
one of them (a different one each time) prints very small (about an inch
tall) in the upper left hand corner. I am printing from a network file but I
don't know if this has anything to do with it or not. Please HELP!!!
...how to get the system setup time.
I want to get the system setup time.
but this code didn't work!
CreateFile always return -1, and the error code is 0x00000005!(Access
if (GetWindowsDirectory(path, MAX_PATH)==0)
HANDLE h = CreateFile(path,
NULL, OPEN_EXISTING, FILE_ATTRIBUTE_NORMAL, NULL);
break; // always return Access is denied.!
FILETIME ft1, ft2, ft3;
if (!GetFileTime(h, &ft1, &ft2, &ft3))
thank you !
Buried in the MSDN documentation for the CreateFile function, there...Can you have a Territory without a manager ?
Can you have a Territory without a manager ?
Is it required ?
Yes you can have a Territory without a manager.
Just a little tip, all required fields are indicated in red, bold letters
and all business recommended (ie suggested you fill this information in)
fields are indicated in blue, bold letters.
Microsoft Business Solutions CRM
> Can you have a Territory without a manager ?
> Is it required ?