Excel keeps changing my formulas to include nearby cells.
Excel keeps changing my formulas to include nearby cells.
More details ...
> Excel keeps changing my formulas to include nearby cells.
many of the fonts (all are true type or O type) that
appear on my font list don't work in publisher? i
highlight the text, change fonts...nothing. any clues?
This is caused by a video driver issue. Go to the website of your video
card manufacturer and download and install the latest version of the video
driver for your video card.
Pushing F9 twice will also cause a re-draw of the screen which should work.
...How do I calculate the change in stock price in excel.
How do I calculate the change in stock price from the previous day.
Put yesterday's price in cell A1 and today's price in cell A2. In cell A3
put the formula:
> How do I calculate the change in stock price from the previous day.
...is there a spreadsheet for class lists?
I am trying to use a Microsoft Works spreadsheet to set up class lists and
what the students have paid or owe for their class participation. Is there a
spreadsheet template for something like this or a suggestion of how to set up
a spreadsheet to do this?
> I am trying to use a Microsoft Works spreadsheet to set up class
> lists and what the students have paid or owe for their class
> participation. Is there a spreadsheet template for something like
> this or a suggestion of how to set up a spreadsheet to do this?
Maybe you can find something useful here:
htt...How to change appearance of the links, pointing to subdocuments in the master document
I want to change the appearance of the links, which are pointing to subdocuments in the master document (Word 2003).
Specifically I want those links to look more descriptive with regards
to their contents - specifically making those links to appear like
those are entries in the Table Of Contents (like it would be looking
if those subdocuments were just paragraphs in the single monolitic
document). Please note that I DO NOT want to rename the filenames of
those subdocuments - I just want to change the appearance of the links
to those documents, in the way I already described above....Excel should have a "Change Case..." menu Item like Word!!
See the subject, I know you can set up a formula to do it I want a button!
PLEASE, for years I've just wanted to change case on the fly, YEARS!
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 message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=3c7554c...Exporting and Importing data
I am replacing my bosses machine with a new dell laptop.
I need to move his outlook over and he wants it exactly as
it is on his old machine.
Will someone explain the easiest and most efficient way to
If you are using exchange mailbox then the only thing you need to move over
is your boss's .pst and .pab files. If he don't have those two files then
you don't need to do anything. All the information is stored on the server.
Just reconfigure the new Outlook with his exchange mail information.
"lsoliz" <firstname.lastname@example.org> wrote in...look up a selection of data
I would like to transfer or look up data when keying in a reference
number and bring up all the data regarding the ref number
Cell A1 = 101, B1 = John and C1 = january
Cell A2 = 102, B2 = Mark and C2 = january
Cell A3 = 103, B3 = Sam and C3 = February
Cell A4 = 101, B4 = John and C4 = March
Cell A5 = 101, B5 = John and C5 = June
When I key in Ref 101 in a chosen cell (eg.A10) then the display should
have all the details
Cell A11 = John, B11 = January
Cell A12 = John, B12 = March
Cell A13 = John, B13 = June
I assume A11, A12 and A13 should also have formulas to generate data
but I c...Smart list data not in tables
I have alot of data that for some reason is in the smart list but is not
veiwed in the tables....any easy way to get the data back in the tables.
Have you used some tool like Query Analyzer to view the suspected tables? If
you will tell me the SmartList you are trying to view, I'll give you the
tables. There is no way SL is showing nonexistent data; it's just a report
"Mike R" <MikeR@discussions.microsoft.com> wrote in message
>I have alot of data that for some reason is in the smart list b...Writing data back to main form
I have a form that pops up when a certain value is selected in an Option
Group on my main form. The user enters free from data in an unbound box on
the popup form, then submits the "comment" through a background macro. The
macro should write the "comment" back to the main form via a SetValue
command, however, the macro is halted because it can't find the original
form, which has remained open. Is SetValue the correct command to use in the
...Smart List Error Message
The following error message pops up when attempting to start the Smart List
in GP v. 9.0:
The user is asked whether they would like temporary or permanent access.
Whichever you choose if you hit OK enough times you will finally end up with
access to the Smart List.
The error only occurs for users who have restricted access to the system to
certain parts of the system.
It seems that you have removed access to the SVC_Explorer_Background_Custom
form in security in the Field Service module. That is "bad" as you've
noticed. You mu...Retreiving Data From CBM Tables
I'm facing some problem in retrieving CBM Tables in order to design a report
for my customer. For my report I want to list out the Payments Posted Records
from CBM and for that I have joined the two tables i.e. CB900035 & CB777001
BELOW IS MY QUERY:
SELECT B.CHEKNMBR, A.CHEKBKID, B.CB_Trans_Amount, B.CB_Type_Description,
FROM CB900035 A, CB777001 B
AND A.CHEKBKID ='BatchNO'
In some cases the...Get external data locks csv file
I have a scenerio where I am querying a csv file off from a network
drive using excel. This file is appended with information written by
When I import a text file using a database query with the microsoft
text driver I intermittently experience a permission denied on the
computer writing to this csv file.
There is no need for excel to lock the csv file qhen querying (as I
not writing to the file).
I modified the DSN file to add readonly=1 which did not work. How
can I resolve this issue?
Thanks for your help.
...Is there a definitive list for when the SA user is REQUIRED?
Some of my users insist they need to use the SA login to do their job. I was
under the impression that very few procedures require SA, such as creating a
new company and creating users.
I've asked this question once before, but I'd like a more definite answer so
please don't respond unless you have a complete list. If someone from
Microsoft could respond that would be great.
Rather than trying over and over for a definative list, which you didn't get
last time(s), why not tell us what specific process they claim to need the sa
login for? You will get a prompt res...Pivot Tables as Data Source
Does anyone know how to create a Pivot Table with
multiple Pivot Tables as it's source? The source Pivot
Tables retrieve data from different locations and are
structured in the same way as each other, with the same
dimensions - I would like to produce a summary Pivot
...Backing up Money data to online location?
2003 does not allow an easy way to save a back-up to an online location,
such My Yahoo briefcase. I have to take the file, and upload it manually.
Please correct me if I'm wrong.
Will there be an online back-up option in future releases? I'd like to see
it go to MSN via my Passport, for instance. I'd upgrade for that.
Given the size of a backup and the availability of sync with the web, this
might not make it anytime soon.
"Iron Flatline" <email@example.com> wrote in
> 2003 doe...Extracting Data in Cells in order -- (or) eliminating empty cell space in a column
I have this problem that I bet is easy to solve, but i am lost. I am an
expert at the slow way to do things, but maybe there is a better way.
The only way I can describe the problem is by means of an example.
Lets say I have a column of numbers:
>_A_|_B_| etc >>
and then i write a little function in the adjoing cell, B1:
From there I fill down column B to B9.
OK, pretty simple so far, right? What I am looking for is instances
where I find a '3' in co...Updating Share Point list from within Excel
I have the need to update an existing SharePoint list within Excel using VBA
code. Is this possible? Can somebody point me to some reference that can
direct met on how to do it?
I'm able to save workbook and create dashboard from that workbook. However,
now I need to update custom fields in an existing list.
...looking for a script to make a Distribution List from a text file
Does anyone have a script for making a new Distribution List from a text
file, or CSV file?
I created larger dist lists by using adduser. Then, once the group is
created, I mail enable it.
> Does anyone have a script for making a new Distribution List from a text
> file, or CSV file?
...reduce size of mail store?
I've been gradually reducing mailbox limits and forcing users to archive to
reduce the size of the mail store. However it does not appear to be
shrinking. I thought daily mainteance routine would compress. Is there
anything to do other than an offline compress and defrag? I really don't
want to have to do that unless as a last resort.
Is your server running low on diskspace or are you having performance
Jason T. Parker
> I've been gradually reducing mailbox limits and forcing users to
> reduce the size of the m...adding cross-functional flowchart changes page-layout
i would like to add to a "landscape" page a
stencil>flowchart>cross-functional flowchart shapes vertical.
when adding it the page converse automatically to a "portrait" page,
while it should remain "landscape"
the same happens if I add cross-functional flowchart shapes horizontal
to a "portrait" page. it changes into a "landscape" page.
can I avoid this?
I can't think of a way to avoid having the page orientation switch to
portrait when you drop the functional band shape out and pick vertical.
Visio automatically cha...Changing to Outlook
I have been using Outlook Express and now have Outlook. Have been able to
import address book and mail but emails are still coming to Express. How do I
change things so they come to my Outlook inbox? Thanks
You have to setup your account(s) in Outlook (Tools\Email Accounts in 2003)
and then quit using Express. You can also import your mail, address book,
and account settings from Express using the Outlook Import/Export tool
(File\Import Export...). Afterward, you should delect your account in
Express (Tools\Accounts\<select mail account>\Remove) so that you do not
accidently do...text dropped when printing
Sometimes when using several lines of text in a cell
with "wrap text" the last line is dropped when printed,
it shows on the monitor but does not print. Any idea why
this is happening? Thanks.
Are you using a true-type font?
"Carol" <firstname.lastname@example.org> wrote in message
> Sometimes when using several lines of text in a cell
> with "wrap text" the last line is dropped when printed,
> it shows on the monitor but does not print. Any idea why
> this is happening? Thanks.
...Drop Down Box Help
Hi I am new to using Excel more interactively. I am able to create
drop down box so a user can choose a day of the week for example.
But I want to be able to populate other cells in the column dependin
on the choice from the drop down list.
e.g. choose Tuesday from a list of days of the week in A2 and have B2
C2 etc filled with related data.
Is this at all possible?
Thank you in advance
smckay's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3582
View this thread: http://www.exc...Hooks & sending data to the Pole Display
I am trying to send my own text during a transaction to the pole display. I
have everything in place and outside of RMS I can send stuff to the pole
display out the COM port, but when the hook is running during RMS POS I can
not my dll to talk out to the pole display. Is there any tricks to this that
anyone has found?
> I am trying to send my own text during a transaction to the pole display.
> I have everything in place and outside of RMS I can send stuff to the pole
> display out the COM port, but when the hook is running...