can't save changes to workbook; ready only
We use and Microsoft Excel Workbook as our database and I am the primary
person that makes changes and those changes are saved on the other two
people's copies who work in the office.
This morning when I tried to save changes it would not let me and changed my
copy and their copies of the workbook to a [read only] [shared]
[compatibility mode] database.xls
This when I clicked save a box came up stating that there over 265 persons
using the database at this time. Which can't be possible since we only have 3
people in our office who use it only a daily basis.
It was ...Can I stop formatting changes from appearing in "track changes"?
Operating System: Mac OS X 10.6 (Snow Leopard)
Under track changes preferences, I have "none" selected, yet formatting changes still show up when I chose to display the changes in balloons. I can accept most of the formatting changes in order to eliminate the balloons, but sometimes I click to "accept" 10 or 20 times, but the balloon won't go away. <br><br>I realize that this is only a problem with balloons, but my pagination gets messed up if I don't use balloons.
Yes: Turn off "Keep track of f...ACC2000: change string to int
I have a customer number that is a string, but I need to change it to an
integer variable. Assigning: iCust = sCust does not work. (I just want
to drop leading zeroes in the string. It can stay a string if that's
Is there a function to convert string to int? I could not find one in
Access help. String() seems to convert a numeric to a string data type.
If you want to find Help on these types of functions, first open any module
and then open Help.
Microsoft Access MVP
If I have helped you, please help me by donat...How do I change my "Personal Contacts" to just Contacts?
My computer crashed but not before I saved my Outlook folder. The problem is
how do I import all of the data (emails, contacts, calendar) into the right
places? The old was 2003; the new is 2007. As of now, the old "Outlook"
folder is sitting on my new Desktop, which probably doesn't make the most
sense. The main issue is that all of my contacts are listed as "Personal
Contacts" when I really want to make them just "Contacts" in general and
create a subset of truly personal contacts. Thanks.
> My computer cra...How can i change chart data point format based on value?
I have a simple column chart with a single data series. I would like to
change the color of an individual data point column depending on value.
Thanks very much.
You want to make a conditional chart:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
"Harold96" <Harold96@discussions.microsoft.com> wrote in message
>I have a simple column chart with a single data series. I would...conflict w/Microsoft Outlook & Outlook Express
when i try and send an email i get the message "there is
no default mail client or the current mail client cannot
fulfill the messaging request". please run Microsoft
Outlook and set an the default mail client. I don't wanrt
to use Microsoft outlook, i want to use Outlook Express.
In internet options under programs outlook express is set
as mail default. PLEASE HELP ME SET THIS PROBLEM RIGHT.
Go to control panel, internet options, programs, and set OE as your default
sandy lanzet wrote:
> when i try and send an email i get the message &quo...Open form based on selection
I have a form [frm_modelselect] where I will select a chair model. Then I
want to hit a command, or just have a macro that runs onChange.
Either way, I want to open a specific form based on the Model that I
selected in [frm_modelselect].
How do I go about doing this?
Thanks in advance.
On Mon, 30 Apr 2007 14:24:04 -0700, Tdahlman wrote:
> I have a form [frm_modelselect] where I will select a chair model. Then I
> want to hit a command, or just have a macro that runs onChange.
> Either way, I want to open a specific form based on the Model that I
> selected in [frm_...cannot change part of a merged cell
This is the error a user receives when he tries to copy one cell into
another made up of 3 merged cells.
Sometimes it works and other times it doesn't.
Is this a fluke?
Copying one cell to a merge of three cells should work.
Are you "sure" it is only one cell that is being copied each time?
Maybe "sometimes" it is one cell and "other times" more than one.
Gord Dibben Excel MVP
On Tue, 8 Jun 2004 14:02:57 -0400, "Dominique Schroeder"
>This is the error a user receives when he...GP BOM should be able to select variable BOM from date or range
I had a request from prospect to see if GP could allow their Mfg Mgrs to
create a cutoff or date range from which to select different BOMs.
They wish to change ingredients used in a dietary supplement starting
Tuesday. Work orders from Tues onward would use an alternate BOM. All work
orders prior to Tuesday would used the original BOM. There are other similar
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the...Want to do in MS Pub. what I do w/Indesign:Create book from mult f
If I could use Indesign at work I would, but all that I can get my hands on
is Publisher. They have not loaded it yet. I have never worked with it, nor
seen it. I am hoping that it will have the same option as Indesign or
Quark.Xpress. I am putting a large manual together. I have many sections, all
in separate files. I want to be able to, as in Indesign, select all of those
separate files and create a book, be able to reorder, add, or delete files as
I want to , and then use one command to print all of those separate files, in
the order that I specified all at once. I am not looking to...Change pivot chart options
Is it possible to modify fields through VB on pivotcharts? For instance I
have a chart that shows sales per date. And I'd like to use the same chart
to show sales by month or sales by week without the user having to move
things around themselves. I can easily set up 2 different Pivotcharts but
that seems redundant if they use the exact same layout and data.
...Change system message
When you have a combo box where you must choose something from a list and the
list to list property is set to Yes the message that comes up is "The text
you entered isn't an item in the list. Select an item from the list, or
enter text that matches one of the listed items" I would like to personalize
that message based on the control (this so I can change the message depending
on the control - different control different message). Is there a way to do
Sarah, use something like this in the NotInList event for the combobox:
Private Sub Combo10_NotInList(Ne...changing columns in the select names dialog box
Outlook 2003 using Microsoft Exchange Server.
1) Is it possible to change which columns display and in what order in the
"select columns" dialog box?
2) I have found that I can remove a column by dragging and sliding a column
to the left against the next column on the left. Unfortunately I have
removed some columns that I would like to see. How do I get the columns to
2) That's a tricky one! It took a couple of minutes for me to figure =
out. Position your mouse pointer exactly over the divider on the left =
side of the colu...Changing format of a particular point in a series (conditionally/vba)
I have a single series which is charted each month and want to
automatically format one of the points (a bar) a different colour.
Is it possible to do this automatically?
thanks for any advice
david marcus - note the email address will not work
Click once on the particular bar where you wish to have
different color, system will select all bars in the chart.
Click once again, the system will select only the bar
that you are clicking on. Call out Format Data Point and
select the desired color or pattern.
>I have a single series which is charted eac...Area Pages Display Problems
When I launch GP and select any series, for example, Financial. The area page
on the right provides varios categories.
In the Financial Area page, one of the Category is Cards and then underneath
cards it has Financial (To the the left of Financial there is a + or - icon)
and then Financial has several access items such as account, checkbook, etc.
The problem I am running into is when I click on the + icon it expands the
category properly and changes the icon to - correctly. Then when I click on
the minus icon it shrinks the category, but instead the of changing the icon
to + it chan...Change XY tick labels from numeric to text
Hope you can help.
I am exploring a huge dataset of data by U.S. zip codes.
Each row is a zip code, the state the zip belongs to, the state number,
and a count of widgets.
91234 AK 2 0.123
91872 AK 2 0.234
91232 AK 2 0.345
26271 AZ 3 0.111
23111 AZ 3 0.222
Although this might sound strange, I am graphing the entire dataset as
an XY scatter plot --- with the state number as the x values and the
widgets as the y-values. The resultant plot shows the distribution of
widgets for each state very quickly and easily and all on one graph.
I...How do you have a print preview if you have no printer attached b.
I was able to build a spread sheet then look at the print preview to make
sure all was going to print correctly. I have no printer attached at this
point but do take a floppy to another office if I need to print. Suddenly
that print preview does not work. How can I solve this problem? Can I set
up a dummy printer without the computer balking?? Thanks!
And the short answer is: Yes
Just use Skip when it offers to print a test page
remove CAPS in e-mail address
"BeckyGTx" <BeckyGTx@discussions.microsoft.com> wrote in me...Background Sizing
I am creating an ad in Publisher and I specify the size on the ad on page set
up. Everything is fine until I add a background - the ad is then larger than
the settings I entered.
Backgrounds want to cover the entire page with a little left over. What size is your
ad? What happens if you create an autoshape and fill it?
Mary Sauer MSFT MVP
"Jen B" <Jen B@discussions.microsoft.com> wrote in message
>I am creating an ad in Publi...using a popup to make percenatges on selected cells
I'm hoping someone can help with some code.
I'm selecting a group of cells containing numbers. I want via a popup to
change the selected numbers to the percentage entered in the popup.
For example - I select my cells and run the macro. The popup asks for a
number and I enter '50'. All the selected numbers then change to 50
percent of their previous value. It would apply equally to a selected
whole column of numbers.
Grateful for any help.
Dim n As Double
n = InputBox("enter a number")
n = n / 100 ...having one field display when another field changes
I have a field CHSTAT that updates in the original database I want a new
field that will display something different as the CHSTAT updates and changes
ie. CHSTAT = "10" new field = "Printed"......CHSTAT = 20 new field=
In tables and fields you should have a table that has a field that has the
CHSTAT values and a field that has the equivalent text values.
Then you join that table to the current table in a query on the CHSTAT values.
If you want to do this on a form, you could use a combobox to select the
values. The source ...How to react on changes in the real world?
How can a CRM Solution have valid information, if you can't change settings
from the systemusers? You can't delete them, you can't move them from one
business unit to another, etc.
Is there any solution for this problems?
Actually, you can change the business unit by going to the user entry form
for a particular user, clicking on Actions, and then on Change Business Unit.
You can also change their manager, add them to different teams, manage roles
within CRM, reassign records, etc.
The only thing you are unable to do is to change their AD login name and
delete users. You c...Message Size Limit #6
I set "102400" Maximum(KB) in the "Sending Message Size" in the
"Message Delivery" in the "Global Settings" in the ESM
but the server reply "This message is larger than the current system
limit or the recipient's mailbox is full" and the attachment is 7612KB
Can anyone give me some insight?
> I set "102400" Maximum(KB) in the "Sending Message Size" in the
> "Message Delivery" in the "Global Settings" in the ESM
> but the server reply "This message is larger than the c..."Autosave" changes active worksheet?
Small, but annoying, problem.
Using "Autosave" while working on a workbook with sheets 2 & 3 showing.
When the Autosave function kicks in it changes one of the displayed
sheets (typically "xls.1) to sheet #1 .
Is this "just the way it works" or am I missing something?
Also, am I correct in assuming that Autosave actually saves the
workbook(s) (i.e. overwrites the original) or does it create a backup
Hi RWN I can't answer your question but I find that the...Change Xcel Amortization from 30 years to 40 years?
In using Xcel Mortgage Amortization templates, I find they are limited to a
30-year amortization. I would like to change them to 40 years or more. The
worksheets are protected, but I am unable to "fill down" the columns to get
them to calculate beyond 30 years.
I don't know anything about Xcel Mortgage, but amortization tables aren't that
complicated. One thing you might try is copying the data to a new spreadsheet,
which you should then be able to extend. Either that, or build your own
"onroad80" <onroad80@disc...Name change in SBS 2000
I've spent 30 minutes searching through the groups and have not found
the golden egg so I'm posting. Need some help with an email issue.
Lady left the company and although strange, her husband was hired to
replace her. So really all that I wanted to do and needed to do is
change the first name on everything to get him good to go. Well after
doing this when he sends an email the display name on the received
email still shows her name even though its coming from his address.
This is what I've done and know:
1. Renamed the account in users under AD.
2. Changed the name on ...