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...MS CRM 3.0 and Exchange Server 2000
I have a query regarding installation of CRM E-mail Router. I have a MS CRM
3.0 installed on a Windows 2003 Server, we're using a Exchange Server 2000 on
W2K Server SP4, can I install the Router on the Exchange Server 2000?
check the implementaiton guide, it gives you system requirements
"John Ding" wrote:
> I have a query regarding installation of CRM E-mail Router. I have a MS CRM
> 3.0 installed on a Windows 2003 Server, we're using a Exchange Server 2000 on
> W2K Server SP4, can I install the Router on the Exchange Server 2000?
I have...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" <email@example.com> wrote:
>Under Look In options
>Find allows for search by formulae OR values OR comments
>Replace is restricted to formulaes ONLY
...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?
...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...A Linking Problem
Assume I have a column of numbers, in a file named Source. (range is B2:B10).
These cells are linked to a column in a file named Destination(range is
If I add a new row 5 to the source, is there a way I can get the previously
linked cells in Destination to continue to display the correct values.
After adding the new row 5 in source, rows in Destination below row 5
display values from rows below (in the Source file).
I hope this is not too confusing a question (I am confused).
If it of importance, the linking was done using Paste Link in the Paste
Yo...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" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Can you tell ...Form printing problem
I have a form that holds customer records which we have been printing out
for filing. I put a print record command button at the top of the form and
this has been working perfectly for at least the last four years printing on
plain paper using auto selection on the printer. Recently the form record has
started printing onto header paper. It doesn't matter whether I change the
properties on the printer it keeps printing to headed paper and the only way
round was to put plain paper into the headed paper tray.
We have now a new printer in the office which has been set as my defa...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...Problems creating a newsletter
I chose the form "Newsletter - email".
I have created a 3 page newsletter. Now, I have NO IDEA how to send it
out as an email. I do not want to send it as an attachment. I cannot
figure out which "save as" format or what I need to do so that i can
email this newsletter. Is there a website that goes through how to do
Am I correct when I say that it has to be html in order for me to send
it as email? That is not one of the options.
Any help you give me would be greatly appreciated.
I am using 2003 Publisher. I created the book "Tri-Puzzles for
Genesis - I"...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]
...Hotmail Problem Please Help
I am running Exchange 2003 Standard on a Windows 2003 Server. I also have ISA
2000 on the same box. Everything is working fine. The problem I am having is
getting mail out to a hotmail address.
When I send then mail, I see it sits in the Queue for less then a minute
then disappears. It never makes it to the Hotmail address nor do I get any
return errors back in my client indicating the mail never made it to its
On Sun, 13 Nov 2005 15:51:04 -0800, "Kevin Mc" <Kevin
>I am running Exchange 2003 Standard on a Windows 200...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
&...Windows 7 taskbar API problems
The background is that an Access MDE/ACCDE created by a developer is
not conceptually the same as an Excel spreadsheet or Word document
file created by the user. My Auto FE Updater utility automatically
downloads any new version created by the developer from the server to
the workstation as well as doing lots of other stuff such as creating
shortcuts on desk tops. If this was a user created Access database
file which resides in the users My Documents folder, or similar, than
they are conceptually the same as a Word or Excel file.
The problem is if the user right-clicks on...Deleting Multiple Public Folders
I have Exchange 2000 installed and I had configured a newsfeed. That made
about 65,000 public folders and I later decided to remove the newsfeed. I
can delete the folders one by one but I can't seem to delete them all en
Does anyone know how to efficiently delete these public folders?
Unsubscribing from the newsfeed first, of course.
Can you delete multiples using Outlook?
"Marvin Miller" <email@example.com> wrote in message
> Hi Folks;
> I have Exchange 2000 installed and I had configured a news...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!!!
...EXCEL 2007 acting up
j$ = "THIS MACRO WILL ERASE THE SECOND & THIRD SET OF DATA" + Chr$(13) +
Using EXCEL 2007, I get an error with the line above as a macro.
It does not recognize CHR$.
What am I doing wrong?
Not for me it didn't.
Check for MISSING references in Tools>References, uncheck them if there are
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"pcor" <firstname.lastname@example.org> wrote in message
> j$ = "THIS MACRO WILL...problems loading excel documents
When I try to open up an excel document via my documents
it says that the same document is open already how can
this be stopped
First try the standard fix(es)......Tools>Options>General uncheck "ignore
OR Start>Run "excel.exe /regserver"(no quotes and note the space before the /
You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to Excel\somewhere\excel.exe" /regserver
Gord Dibben XL2002
On Sat, 15 Nov 2003 09:16:14 -0800, "Tina" <TinaSCovell...Outlook/Exchange 2000 connection problem
I appologize if this is not the correct newsgroup.
Situation is the following.
From some workstations (Win 24 Pro SP4, Outlook 2000) in the network,
when I create Exchange service and click "Check Name" button i get
message "The name could not be resolved. The operation Failed." This
happens both when I enter Exchange server name, and IP. If I try to
resolve name that does not exist, the message is "The name could not be
resolved. The name could not be matched to a name in address list." Ping
and nslookup work fine, OWA also. I even tried to reinstall Windows...setting a date type field to null
I have defined a variable in my vba code as date. I am trying to set its
value to null but I get an error.
Dim HoldDate as date
Holddate = ""
I have several other fields that are text that are obviously fine, but I am
not sure how to set a default for the date type field.
I need to initialize the field after I write a record out before processing
Any help would be appreciated.
On Thu, 13 Dec 2007 21:06:00 -0800, KSH wrote:
> I have defined a variable in my vba code as date. I am trying to set its
> value to null but I get an error.
&g...how to convert word file into excel file
If any body know about how to convert MS Word file into MS Excel file please
let me know.
I am unable to do so.
> If any body know about how to convert MS Word file into MS Excel file
> let me know.
> I am unable to do so.
> Help me
Try Copy and Paste
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24783
View this thread: http://www.excelforum.com/showthread.php?threadid=467752
Dear Pau...auto file path update when excel sheet moved to another directory.
I've been working on a huge excel file for a while and I'm trying to make
it easier to use. My problem is that when it is moved from the template
folder to a working folder the formulas referencing a file in the template
folder have their path changed in the formula and have to have the links
updated. Since the file is protected it's impossible for the users to chance
the source. It's wierd because it will still pull information, but if
information is changed in the external data file the updated doesn't get
I need some like the $ command to ...Macro with relative address problem XSL 2000
Basically I want to (and did at one time) create a macro that edits a
number (zip code), inserts a leading zero then moves down one cell.
With the cursor on A1 my steps are:
Tools\Macro\Record a New Macro\z
On Stop Recording Toolbar depress Relative Address, then
Click Stop recoding
Since the cursor is on a A2, Pressing CTRL+z will make the contents
01234, not the desired 02345.
I've tried different combinations of when to depress the relative
address button with no success. And double clicking the c...