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...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...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...Excel Functions
I am calculating a Daily total as well as an accumulative. I need to
subtract the previous days figure from the accumulative to get the current
days total. Each Day I only have the accumulative figure to work with and
need to set-up a function within my spreadsheet to do this - I have worked
with this formula so far... however it only works for the 2nd day and will
not put a new figure into the 3rd days cell.
Show the layout of your data, with some example values
> I am calculating a Da...Excel decision
I have a spreadsheet. I need to compare 2 columns and have the smalle
of the 2 show in a third column. :eek
Reggie2004's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1508
View this thread: http://www.excelforum.com/showthread.php?threadid=38191
"Reggie2004" <Reggie2004.firstname.lastname@example.org> wrote
in message news:Reggie2004.1r4qmo_111961...My Excel 2007 filename is followed by [Group]. Why?
Many of the functions on the ribbon are inaccessible. I noticed that the file
name shown at the top of the spreadsheet is followed by "[Group]". I have
never seen that before on any spreadsheet, and have no idea how it got
labeled that way. I assume that has something to do with the inability to
access some functions, such as conditional formatting. How can I get rid of
[Group] so I can continue to work on the workbook?
You had at least 2 sheets selected (grouped) when you saved the workbook,
right click the sheet tab and select ungroup sheets and then save the ...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...Excel Based Budgeting Error when Exporting Budget to Excel
I have come across the following issue:
When Exporting an existing Budget to Excel I am receiving the
following error message:
Exporter: UNKNOWN ERROR: Maincode.ExportBudget() Unknown Error
Occured: Error: 53: Animation description: File Not Found.
I have been able to re-produce this error on all machines within the
organization that have access to the Excel Based Budget and I have not
been able to find anything on knowledgebase.
Any help on resolving this issue will be greatly appreciated.
Please note that I am currently on Version 8 SP 5 fo Great Plains.
------=_NextPar...SpreadSheetML (XML for Excel)
A client of mine has Office X for Mac. I am wondering if this edition
of Excel supports SpreadSheetML. I have heard that it also support the
new Open XML formats (same as Office 11). Does anyone know if either of
these statements is accurate?
Thanks in advance,
I believe that both statements are wrong.
The XML converter for Office Next on the Mac has not yet been developed.
It's not likely to come until after the PC Office team ships their product
to retail -- until they stop CHANGING the thing :-)
My guess is that the converter won't appear until sometime...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...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...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 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...Error msg when opening Excel (but works anyway)
I have macros in my file. When I open it I get a msg:
Cannot find 'C:\Program files\Microsoft Office\Office
11\Library\Msquery\Xlquery.xla'!Register.DClick, which has been assigned to
run each time .....file is open
My file works anyway. I have a refresh to ACCESS (query).
This is annoying....how can I get rid of the msg. thx
Hi Greg, did you resolve your DClick problem at all? I ask because I am
getting the same error when I publish a document to Sharepoint Team Services
- doesn't happen under any other circumstances: different user access right
levels, running local...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
...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...excel #126
uses of excel
Is this a question? If so, excel is a spredsheet! If not, why did you post?
> uses of excel
...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...converting copied data to numbers in excel xp
I tryed following the instructions for converting text to numbers and it
I am sure someone has had this problem. Any help appreciated.
Have you try this
Copy a empty cell
Select the cells with text values
Right click on the selection
Choose Paste Special ..... Add
Regards Ron de Bruin
"knutsenk" <firstname.lastname@example.org> wrote in message news:76657387-710D-4387-B616-C29AB3EAD360@microsoft.com...
>I tryed following the instructions for converting text to numbers and it
> didn...Excel 2007 VBA
I try to run a VBA code that woks fine in Excel 2003 and it crashes in 2007.
The offending line is
What could possibly be wrong with that?
On Mar 29, 5:42 am, "teepee" <tee...@noemail.com> wrote:
> I try to run a VBA code that woks fine in Excel 2003 and it crashes in 2007.
> The offending line is
> ActiveSheet.ChartObjects("Chart 542").Activate
> What could possibly be wrong with that?
I apologize if I'm asking the obvious question, but does Chart542
exis...How do i change the cells in a column at the same time in Excell?
You post is way thin on details and to insure you get some goo
feedback, it is important to take the time to be a specific as possibl
about what you want to happen.
That being said; here is an example of changing an entire column'
If you want to apply the same formatting to all the cells in a column
click on the column letter A,B,C........, you will notice that th
entire column is highlighted. Now, go straight to Format>Cells an
begin selecting the formatting changes you would like. These change
will be applied to the entire selected column.
Hopes this helps,