"Add data" to chart menu command won't work
Operating System: Mac OS X 10.6 (Snow Leopard)
When I try to use the "Add data" command from the "Chart" menu, the "Add Data" window opens, but when I select the data range from the spreadsheet and click "OK," nothing happens; the chart doesn't show the new data line. Thanks for any suggestions.
...Protecting user from changing previous data
I have a block of data A1:D10 with Protection using ALLOW USER TO EDIT RANGE.
The user enter data with the following order:
Input 1: A1, B1, C1, D1
Input 2: A2, B2, C2, D2
Input 3: A3, B3, C3, D3
I would like to Automatically prevent the user from changing ROW A1-D1 when
Inserting NEW ROWS (Row A2-D2, Row A3-D3).
This can be a very complex issue if you don't think things out really well
ahead of time. What happens if, after they've typed data in A1:D1 and while
entering more data in rows below row 1, they realize they made a mistake...Linking to a Password Protected Document in Excel 2000
I have a document that is password protected. I also have a file that
references the protected files for many of the its formulas. Each time I open
the file and update the links I am prompted multiple times (once for each
cell reference to the protected file) for the password. Is there any setting
so that a user is only prompted once for the password to a reference file
that is protected?
I know that one option is just to copy the tabs from my referencing file
into the protected file, but it would be nice to keep the documents separate.
One option might be to disable th...Switchboard Button Does Not Work
I've created many switchboards in previous versions of MS Access but this is
the first one I've done in Access 2007 and I've come across a problem that
has not occurred before.
I currently have 2 swichboards (the main one, and a secondary one that is
reached via a button on the main). When the database is first opened, all the
buttons work fine. However, when I run a routine that imports data and then
carries out a number of validity checks on that data (again, something that I
have done numerous times in the past), the button on the main switchboard
that links me to the se...Protection
I just built an applet and want others to be able to use it. Essentially,
when you press the RUN button, it automatically opens 3 files located on
the users' desktop, based upon the answers he provides in two input boxes,
reformats, manipulates the data, eliminates unwanted data and then presents
the data to the user in a form he can use.
I only want the user to be able to input the two data elements, and use the
RUN button - nothing else. I don't even want the applet to be re-saved with
the new data shown - although I'd like him to be able to copy the processed
...Money Plus 08 SP1 & Vista SP1 "stopped working"
Money Plus Dlx 08 SP1 188.8.131.525
Vista Home SP1
I now get power exits with a "stopped working" when selecting the
Investments tab. Everything else seems to work OK. I suspect one or both of
the service packs.
Any ideas appreciated, Don
1. Close Money
2. Bring up Internet Explorer and go to the Choice page:
http://moneycentral.msn.com/investor/controls/setup.asp and choose the Basic
3. Close IE, start Money and see if that resolves the problem.
Alternatively in step 2 delete the moneycentral.msn.com cookie
"dbl30569" <firstname.lastname@example.org...How can I use open/close Grouped cells in a Protected Worksheet?
Can anyone help me please - When I include Grouped cells in a Worksheet
by using "Data" / "Group and Outline", excell will not allow opening or
closing of the Grouped cells when the Worksheet is protected. Is there
an easy way I can open/close Grouped cells in a Protected Worksheet?
Andy Bowshell's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30469
View this thread: http://www.excelforum.com/showthread.php?threadid=501330
If you already have the ou...COUNTIF Not Working
Can someone please offer some help
A B C D E
1 SPR NFR Week Priority Complete
2 1968 1 1 Y
3 9874 1 1 Y
4 1971 2 2 N
5 1972 1 1 Y
6 9562 3 1 N
7 9745 2 1 N
8 1976 3 3 N
Above are the rows and columns as my example
Goa - I want to know what SPR's (column A) have a 1 in the Week(C
column and also have a 1 in the Priority (D) column
The result should be at total of 2 - SPR's 1968 and 1972 both have a
in the Week (C) column and a 1 in the Priority (D) column.
Any help would be greatly appreciated
Message posted from http://www.ExcelForum.com
On Fri...Sorting protected worksheet & workbook
Operating excel 2003
I have an excel workbook which is protected but sort has been checked in the
protection box. This worksheet sorts column F into date of birth order.
Oldest at the top using A->Z. I have installed this workbook onto two other
computers at different sites and all sort beautifully in protected mode.
However, I have installed this workbook onto a 3rd computer (once again a
separate site) and it will not allow the sort to happen without unprotecting
the worksheet. All of these computers are running Windows XP and Office
2003. The workbook was designed using the...Spell Check doesn't work in Excel
Operating System: Mac OS X 10.6 (Snow Leopard)
When I go to Tools-->Speling... I get a pop up that reads "The word could not be added to the custom spelling dictionary the word contains incorrect characters.". <br><br>I've checked the setting in word (as per the help menus) but it doesnt fix the problem. Spell chec k works in Word however I see the same message in a pop up when I open a new word Doc. There does not appear to be any updates for me either.
I got the same problem and am looking for the fix. Help?? On 20...Cell format protection
I have certain cells locked in a protected worksheet. The spreadsheet is
used by others who input data in unlocked cells and return to me. My
problem is that when they copy & paste something, they are eliminating the
formats I have all ready set (border, allow numbers only, etc.). Is there
any way to prevent this, while still maintaining the protection of the rest
of the locked cells?
...Excel formula doesn't work when put in from VBA, but works when written in Excel
I have made vba-code that makes a formula to be pasted into one cell at the
time in Excel.
vAktivCelle = "J" & i
vFormel = "=if(E" & i & "=0;if(((G" & i & "+H" & i &
vFormel = vFormel & "+G" & i & "+H" & i & "+I" & i & ")-F" & i &
vFormel = vFormel & "(G" & i & "+H" & i & ")*Parametre!$E$5+G" & i &
I've protected a column of cells in my worksheet, but I've also set it so
that rows can be added and deleted.
But if I try to insert a row and copy the data from an existing row, I get
an error since I'm trying to 'update' the protected cell.
A similar problem happens when I try to delete (I'm assuming because one of
cells is protected and it thinks I'm trying to change it.)
What's the purpose of allowing adding and deleting rows to protected sheets
if it doesn't work when a row has a locked column.? bIs there any way around
Just as ...DPM 2010 RC: secondary protection in workgroup mode
In DPM 2010, what is the process for adding attaching a Primary Protection
server in workgroup mode?
I attempted to use the same process for adding a Production Server in
workgroup mode (setdpmserver.exe -isnondomainserver ... ) but you can't
install the agent because, "Protection Agent cannot be Installed on machine
where DPM is installed" - the error I receive when trying to run the DPM 2010
Are you trying to protect a DPM server by another DPM server using
workgroup/un-trusted domain way? This is not a supported scenario. Pl...'Remember Password' does not work
I click the Remember Password box in MSM Premium 05 and it never works. This
is the buggiest pos I have ever seen!
Money 2004 has had the same problem since last year when Microsoft had a
problem with .Net passport.
"Yet he can see through a brick wall in time. (As they say in Bree)"
Time and change will surely show
How firm thy friendship O-hi-o
"Carlos" <CJrodriguez@msn.com> wrote in message
>I click the Remember Password box in MSM Premium 05 and it never works.
>This is the...MSP updates actual work when editing work in resource usage view
Hi, we recently switched to a master project arrangement for all our
projects, which brought on the need to use resource usage view to hand edit
the distribution of remaining work for each resource/task.
This has generally worked fine, except recently we've found this very
annoying problem - when we alter the work values, MSP is actually also
modifying the actual work values with the same numbers - why would it be
Heres an example:
Task1: Res1 has completed 5 hours of actual work, and has 4 hours remaining.
These are scheduled for a Monday in 3 weeks, and ..."Protect Sheet" #2
Apologies if this appears to some as a duplicated post. For some unknown
reason it hasn't shown in my listings.
I am using Excel 2007 with Vista Home Premium.
I have 15 workbooks, each with 12 sheets. I want each sheet (not the
workbook) password protected to prevent any accidental to interference with
With a total of 180 worksheets I am a bit disappointed there is no way other
than protecting each sheet one at a time entering each password twice...!
......Or am I wrong? I sincerely hope I am.
Can anyone help?
See answer in your other post.
OK my problem is I am using an offie computer that everyone has access to and we cannot - and do not want to - change this. Is there a way that I can put a password for my profile on Microsoft outlook so that no one can read the new AND the old messages found in my inbox?
You can put a password on your PST file, presuming you use a PST file...
Emad Kamel wrote:
> Hi everyone,
> OK my problem is I am using an offie computer that everyone has
> access to and we cannot - and do not want to - change this. Is there
> a way that I can put a password for my profile on Micr...Protecting Sheets #2
I have a workbook which has about 120 worksheets. Is there any way to set
the Worksheet Protection on all sheets at one time? I want all sheets set to
allow only the selection of unlocked cells.
Public Sub ProtectSheet()
For Each sht In Sheets
Patrick Simonds wrote:
> I have a workbook which has about 120 worksheets. Is there any way to set
> the Worksheet Protection on all sheets at one time? I want all sheets set to
> allow only the selection of unlocked cells.
...Amex/Costco account update not working
Wondering if anyone else is having issues update and Amex/Costco account in
2006 version. It was working on 2004 version but has been broken since the
Downloads from Amex/Costco work fine here.
Explain what "issues" are you experiencing?
"Andrew" <email@example.com> wrote in message
> Wondering if anyone else is having issues update and Amex/Costco account
> in 2006 version. It was working on 2004 version but has been broken since
> the upgrade.
I had problems wi...Disable password protection on .pst files
Just wondering if there is a registry key change or something I can do using
the orktools that will prevent users from applying passwords to their .pst
files. This is at the request of our legal department who is concerned that
users may leave and their case files and such are now inaccessible to
Mary Patricia <rodgers.patricia@> wrote:
> Just wondering if there is a registry key change or something I can
> do using the orktools that will prevent users from applying passwords
> to their .pst files. This is at the request of our legal department
> who is ...arrow keys are not working
my arrow keys are not working on my spread sheet and the scroll lock has
nothing to do with it
I am working w/a microsoft wireless multi media keyboard 1.1 Andrea,
This newsgroup deals with Microsoft Access, a relational database
You'll have better luck posting this to a newsgroup that deals with
whatever spreadsheet application you're using.
Or... perhaps... a search on the web for any problems associated
with your particular keyboard.
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolut...Outlook 2002 Only Opens in Safe Mode
I am running a P4 2.6 Celeron using XP Home Edition. I have Office 2000
SR-1. I purchased a new IPAQ 5550 which came with Outlook 2002 which I
installed and used without a problem. I then purchased Franklin Covey Plan
Plus v2. After having some initial installation problems I finally got
everything installed. However, when I try to open Outlook I get an error
report and a prompt to open Outlook in safe mode. I tried the support at
Franklin Covey who said it was an issue with Outlook and to check with
Microsoft. I could not find anything on their site to help. Any help with ...Allow user to run a macro in protected mode
I want to let other users of my spreadsheet to run a macro in protected mode.
The macro runs the filter for a big spreadsheet and I want to keep the
protection on but let users run the simple macro that hides the blank lines
Users get Run-time error 1004 when they click on my macro icon
The cells you are manipulating have to be unprotected during the
You can do this by putting this piece of code at the beginning of your
Code = "password"
Then at the end of your code put this
Wo...Password Protection #5
I have a spreadsheet with several sheets . These are accessed via macr
buttons on a main fron sheet (I have hidden other sheets) . Is i
possible to password protect certain sheets so that they cannot b
accessed by the user without the correct password . I can protect the
so that they cannot be changed but need to stop them from bein
Message posted from http://www.ExcelForum.com
First Hide the sheet by going Format/Sheet/Hide on the toolbar.
If you then protect the workbook structure the user will be unable t
unhide the sheet.
Message posted fr...