Controlling Access to Contact's History
Is there a way to set a security role up so a user can't delete items
from a Contact's History? The user would still need rights to read/
write to the contact record.
Go to Settings-->business unit settings-->security roles
Choose a role to edit (other than system administrator, you can't
change that one).
Select the Core Records tab.
History, in terms of tasks and appointments, is controlled by the
History, in terms of notes, is controlled by the Note row.
You can set the read and write "pies" seperately from the Delete
Clear th...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" <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?
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:
...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
...adds staff to access list to ALL PROJECTS if same as their departm
A procedure was written to update all projects, adds staff to access list to
ALL PROJECTS if they are the same as their home department.
It would be useful to know if there were a feature to define default
projects by a given criteria - i.e. By department.
insert accesslest (PACONTNUMBER, PAPROJNUMBER, EMPLOYID, ContractEntry,
ContractInquire, ContractReport, ContractReview, ProjectEntry,
ProjectInquire, ProjectReport, ProjectReview, ALEntry, ALInquire, ALReport,
ALReview, EEEntry, EEInquire, EEReport, EEReview, ELEntry,
ELInquire, ELReport, ELReview, FFEnt...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...smart list go tos
I am trying to change the documents: portion with a go to on the window
"Purchase Order Processing Document Inquiry"
Take a look at my response to this post. However, this was not entirely tested.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusines...Word table to XML
Can some one help me in converting a word table to XML? I am using word 2003
and the macro should word even with word 2007.
Thanks in advance.
Which macro? What is the xml schema for the table?
"Sri Vidya" <Sri Vidya@discussions.microsoft.com> wrote in message
> Can some one help me in converting a word table to XML? I am using word
> and the macro should word even with word 2007.
> Thanks in advance.
...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 ...Pivot Table Axis format
I have a macro that creates a pivot-table and pivot
chart. The X-axis is a date. In the raw data, the date
is formated as month/day. This is the way I want it on
the chart. However, the X-axis formats with
month/day/year. How can I force this to display correctly?
Do you see a grey little dropdown under the X axis (where you can choose your
dates to show)?
If yes, then rightclick on it.
Select the top option: "Format pivotchart field"
then click on the Number button on the next dialog.
There are a bunch of date formats that you can choose from.
Maybe...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...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]
...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
&...How To Access Thru News Server
"The messages are visible if you access the group directly using the news
server, rather than via the unreliable web interface.
David made above comment earlier.
How do you do that please?
Thanks in advance for any replies.
Saved from a previous post:
If you're able (not behind a firewall at work???), you may want to connect
directly to the MS newsservers.
If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).
news://msnews.microsoft...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" <email@example.com> wrote in message
> j$ = "THIS MACRO WILL...how do you change the font size of a drop-down list?
When I use the Validation feature under Data Menu and I create a drop-down
list, the font size of the contents of the drop-down list is too small to
read. How do I change this?
You can't change the font or font size for a Data Validation dropdown
list. To make the font appear larger, you can use programming to adjust
the zoom setting when the cell is selected. There's sample code here:
Or, there's a sample file here that provides a combobox from which you
can select one of the values from the data validation list. In ...How can a value be converted to words
Is there a fromula if I have a total i.e. 123 to be converted in words i.e.
One hundrd and twenty three automatically.
> Is there a fromula if I have a total i.e. 123 to be converted in words i.e.
> One hundrd and twenty three automatically.
...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...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 ...