Spreadsheet shows through desktop
I would bet this is a simple one to figure out.
All of a sudden when I open my XL 2002 spreadsheets,
they all open where the windows and borders are visible/
okay, but the cells are invisible and I can see through
to my desktop. It happens on all sheets, new or existing.
Can someone please help????????
There have been a few posts about this (I've never seen it up close and
IIRC, the solutions varied between closing excel and restarting and even
rebooting the pc.
Not much of a solution, huh?
> I would bet this is a simple one t...picture is not showing up in Excel
I have a picture that is in an Excel worksheet. I can see the handles
and if I move the handles some, the picture will show up. However, it
will not show up in print preview at all or page break preview. I can
open the same file on another computer and it will show up fine.
Any help would be appreciated.
Tools -> Options ->General
Do you have "Show All" selected for Objects?
> I have a picture that is in an Excel worksheet. I can see the handles
> and if I move the handles some, the picture will show up. However, it
> will...Sorting & Grouping On Multiple Fields
Hello, can anyone help me with this? I have four fields in a table call
Team1, Team2, Team3 & Team4. Each of the fields are linked to a lookup table
that has 22 team names. Persons in the database can be a part of up to four
I wish to group my report by the 22 teams. My problem is how do I tell my
report to check all four fields for each of the 22 team names before it
starts to group. For example a person can be in a team call "Hawk" and that
is listed in the field call Team1, while another person can also be in "Hawk"
but have that listed in the field ...getting drop down arrows to show in a form
I have created a form that uses several drop down fields. When I protect the
document, and run the form, the fields do not show the drop down arrows until
you actually click or tab to that specific field.
Is there any way to create a drop down box that will show the drop down
arrow always (like Microsoft does). I'm trying to make the form a little
more "obvious" for users so that they'll know which fields are drop-down and
which are free-form text.
Thanks for your help.
For a dropdown form field in a protected document, there is no such
option. Probably t...Pictures don't print in outlook 2000 or 97
How do I get pictures to print when I print messages for Outlook 2000
or Outlook 97. I'm using XP Home.
Have you checked to make sure you have all of the latest Windows and Office Service Packs installed? I remember this issue from a whle back, and it was corrected in one of the service
Scott Atkins MCSE, MCSA
Partner Technical Lead - Outlook
Microsoft Technical Support
for Platforms and Business Applications
>Subject: Pictures don't...auto update to multiple worksheets
I have created an Excel workbook which contains multiple worksheets of
financial data. what I need to know is How do I get the financial data
totals from work sheet 1 to auto-populate into worksheet # 2, from worksheet
#2 to #3, etc. ?
Maybe a redesign?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
Don Guillett...Embedded pictures
I noticed that the when we set the picture property of a button or another
control as embedded, it takes a lot of place.
Is there an explication that show why the Access file encrease in size by
more than the picture size (even if it is a bitmap, a format that is normaly
An mdb without picture would take 4 MB
the same file with pictures would increase to 40 MB with only 400 KB of
pictures. In JPEG format.
Is it because Access uses a non efficient compression to include the image
Thank you in advance for any suggestion!
PS: I know that I can set the pictur...lookup value based on multiple criteria
Banging my head on this one... can anyone help??
I've got several thousand rows of data in three columns,
structured similar to example below. Each set of ID
numbers represents a separate contact entry (person) in
an address book. FIELDNAME could include one or more of
about 200 fields, and VALUE may be blank.
ID FIELDNAME VALUE
1 FirstName Bob
1 LastName Smith
1 Company Tech Smith, Inc.
2 LastName Johnson
2 Company <blank>
2 FirstName Jim
I've got a second sheet set up with all of the 200
possible FIEL...Inserting picture from "My Pictures"
When I add a pic from "My pictures" the entire picture does not appear on the
slide and when I try to format it it is impossible to get it back to the same
pic I am attempting to add. If I am trying to add a pic I might only get a
nose or a blade of grass instead of the original picture from "My Pictures".
Reduce the zoom to 10%. Coul be a too large image
"PP Neophyte" <PP Neophyte@discussions.microsoft.com> a �crit dans le
message de news: CA5F97E6-D4D8-401B-B066-E261024F082F@microsoft.com...
> When I add a pic from "My pictures" t...Custom toolbar/menu items not showing
I am working on a customization (in GP 8.0 SP4) that includes adding a
toolbar with several command items on it, along with some extra menu items.
When I run in test mode, the toolbar and menu items do not show up. When I
create a chunk file and install it in my GP folder, then run GP, the toolbar
and menu items show up fine. I've done some work in GP 9.0 using the same
scripts to create toolbars and menu items and had them show up just fine in
test mode. Any thoughts?
When you say toolbar are you referring to a Form with a Window of Type
Toolbar? Dexterity ...picture in picture
Have to digital pictures & would like to put a couple of people on one
picture into the other picture. How do i do this? Anyone got any ideas? TIA
"ted medin" <email@example.com> wrote in message
> Have to digital pictures & would like to put a couple of people on one
> picture into the other picture. How do i do this? Anyone got any ideas?
Well not with Vista. You need a Graphic editing application.
The Gimp may be able to do this. (It's free, Open Source but is a bit tricky
yo get to lear...Background Color missing
One user has an Excel 2002 spreadsheet that occasionally contains a "total"
line, which has white text on a green background. Several others share the
spreadsheet and it looks fine. But one user cannot see the "total" lines
because the background does not display green, so the text is white on
white. What would cause this and how can I repair it?
Glen - under tools/options/view/color - the default maybe
set to white. try automatic.
>One user has an Excel 2002 spreadsheet that occasionally
contains a "total"...Picture in Publisher
When inserting pictures in publisher the picture does not show. I can see
the frame. The same thing when I load a publisher file created by someone
else. All the inserted pictures does not show. View>pictures is set to
Any suggestions for a solution?
Read the third FAQ here
Mary Sauer MSFT MVP
"Thor" <Thor@discussions.microsoft.com> wrote in messag...Showing totals in data table in a line chart
I'm trying to show the totals of two data series in a line chart. Everytime I
inlude the cells in the data range the total cells are plotted in on the
chart. Is there a way to dispaly the sum of the cells and not plot the totals
on the chart?
How do you want to display the total?
1. Don't include the totals in the range you select to plot, then add a
textbox and enter the total. To make the textbox dynamic - select the chart
area and type = and click on the cell where the total is. Press Enter. Move
the textbox whereever you want it.
If this helps, please cl...Picture Link
Appreciate some help here and thanks in advance.
I link my pictures to the following folders
C:\Documents and Settings\MyName\Desktop\Picture.jpg
C:\Documents and Settings\MyName\My Documents\Picture.bmp
If Me!pic1a = "X" Then
Forms!startpg!fmpPic!Img.Picture = ""
Forms!startpg!fmpPic!Img.Picture = Me!pic1a
It works on my PC but when I copied the program to another PC, it does not
This is because of "MyName" and the other PC has a different name. Is there
a way to ignore "MyName" for any PCs
"ChoonBoy&quo...Sending pictures with text and then another picture with text.
I receive some e-mails with text and then a picture with more text and again
a picture. Some of these will have 8 to 10 pictures with text under each
picture. But when I send it out it is received with all of the text in a
group and the pictures are all sent as attachments. How do I get my e-mails
to send the pictures and text the way I receive them? Thanks for any help
you can give me. Bob
...multiple iterations of same query
Running Access 2003 on Vista.
I have a query that chooses 15 records at random. This works fine.
What I want to do is run the same query for approx 110 different users, each
with their own randomly selected 15 records. Obviously, I want to avoid
manually running the same query that many times. How can I get around this?
Post your query SQL.
Build a little, test a little.
> Running Access 2003 on Vista.
> I have a query that chooses 15 records at random. This works fine.
> What I want to do is run the same query fo...how do you get rid of the default background of "page 1" in excel
It doesn't give you the option of delete background to clear the default.
I tried to add a blank background and that didn't work either; the "page 1"
stays on the excel sheet. It blocks view of numbers on the sheet and is
Go back to Normal view:
It's a feature of View|Page break preview
> It doesn't give you the option of delete background to clear the default.
> I tried to add a blank background and that didn't work either; the "page 1"
> stays on the excel sheet. It blocks view of num...Picture in header
How do I get a picture in the header?
This was added in xl2002.
File|Page setup|header/footer tab|custom header
There's an icon that looks like a picture near the far right.
> How do I get a picture in the header?
If you are using a version of Excel before 2002 then check out:
for a workaround.
"Dave Peterson" wrote:
> This was added in xl2002.
> File|Page setup|header/footer tab|custom header
> There's an icon that looks lik...Coloured backgrounds using IF
Hi I am looking to format teh colour of cells using their values
equal to or less than 5 Green
6 to 14 yellow
15 and greater red
any help greatly appreciated.
You would use Conditional Formatting to do this - available on the
Format menu. Just follow the Wizard through and choose the Patterns
tab for background colour.
Hope this helps.
On Dec 8, 1:52=A0pm, Simon <Si...@discussions.microsoft.com> wrote:
> Hi I am looking to format teh colour of cells using their values
> equal to or less than 5 Green
> 6 to 14 yellow
> 15 an...Can pictures be centered in a picture frame in a catalog?
I have created a catalog for items we sell. I have added the pictures to the
catalog through the Excel worksheet. When the worksheet is imported, all of
the pictures left-justify in the picture frame. Can this be centered?
...Create picture catalog from current product codes
Any one who knows how to create a catalog of pictures in a=20
spreadsheet, from a list of product codes, that=20
automatically adds the pictures from a specific product=20
code list and creates links from the product code to the=20
specific cell in which the picture is positioned.
Merge Pictures and Words - Oh My!, by Cindy Meister, creates a catalog from text wording and external pictures from an Excel
database. [photos, photographs] http://www.computorcompanion.com/LMMArticle.asp?ID=126
Also see extracting JPG / GIF files from an Excel document (charts).
htt...attaching pictures as an icon
Hi I am trying to save memory in an excel report and I
wish to include a picture in this report as an icon that
shows the picture when selected.
If you're going to try to save memory in the workbook, then it sounds like the
big picture will be outside excel (a common LAN folder???).
If yes, then maybe you could create thumbnails of each of your pictures (using
????) and then add a hyperlink to each thumbnail.
The hyperlink would use whatever program is associated with the extension to
open the big picture--outside of excel completely.
(I don't know how you'd include the big p...multiple pop3 accounts
can I configure Outlook2003 with multiple pop3 accounts so that every
account gets it own inbox and send folder ?
Yes, you have to create the folders and then you have to write two rules, one for incoming mail and one for after sending mail
"Craig" <firstname.lastname@example.org> wrote in message
> Yes, you have to create the folders and then you have to write two rules,
one for incoming mail and one for after sending mail.
I think you have to apply the rule foe sent mail manually ...Create activities for multiple leads
Is there a way to create a "Phone Call" activity for a group leads in one
step? As we import leads, I either want to automatically have a phone call
activity created for each lead or be able to select a large group of leads
and created phone call activities for each one.
Create a manual workflow rule that creates the activity, then using Advanced
Find or a Veiw search/select the leads and choose 'apply rule' to run your
workflow rule against that group - you can only do 100 at a time, but it
works and is easy to set up.