Free Microsoft Excel 2013 Quick Reference

Mouse Cursor Not Showing Up

Hello,

I have been having an issue with one of the employee's excel programs in my office. We are running the 2007 edition. When opening a document in excel the cursor completely disappears. It still has full functionality (if you can figure out where it is).

One odd thing I just noticed is if you have excel open, then open up my documents, the cursor is no longer visible there either. However when excel isn't open the cursor is visible.

I have searched for an answer to this problem, however I have not been able to find one.

I have tried opening excel in safe mode, updating video drivers, and turned down the hardware acceleration on the chipset.

Any opinions would be extremely helpful, I will be checking frequently and trying to resolve this issue quickly because it is making the employee's work impossible.

Thanks,

Peter.


Post your answer or comment

comments powered by Disqus
I am having trouble with getting the cursor to show up when I type. All I
get is the + sign.For instance I have spreadsheet premade and when I go into
the spreadsheet to add new data,there is no cursor to add info to the text
that is already in the cell. ie:
in the cell might say module and I need to add December to make it December
Module, but there is not cursor so what ever I type, it clears the entire box
instead of adding the info to it. Or if I misstype something and try and
correct it. Nothing.
I can change it in the formula bar, but I want to change on the spreadsheet.

Also, when I try to copy and paste say a tracking # in the cell, It goes
into some fourmula and I can right click on the cell, and format cells and go
to #'s and move the decimal point, and hit ok. That changes it, but it makes
me have to right click every cell. I tried highlighting the whole colum and
right click and format and change the decimal point, but it will not change.

I have a pivot table that provides sales data by customer sorted by salesman and division. The report is designed so that sales data is sorted by a 4 digit salesmen/territory code. For example, the James company had 6,959,577 in budgeted sales. If I wanted to move that customer to another salesmens territory, I would change the 4 digit code for that customer on my data tab.

My problem: I have new sales/territory codes. For example D1 Smith was 1301-1600. Now I need to add 1900-2600. I have added the new codes to the data tab. When I calculate, the new codes are on seperate lines and not under the desired saleman. I do not understand how to add the new codes so that they will be under the respective salesmans territory.

My second issue: Some of my data is not showing up. I can drill down on totals and see it but it will not show up on my report.

A simplified version of my report is attached.

Hi Excel Experts,

I have a workbook where users enter data manually. It has approx. 125 rows and 8 columns. The row count will always vary but it will always be only 8 columns. I have given this data a dynamic range name:
=OFFSET(Sheet1!$A$2:$H$2,0,0,COUNT(Sheet1!$A:$A)+1)
Now, what I want to do is to link this spreadsheet into an Access database. However, when I go through the wizards in
Access to link the spreadsheet, and I get to the option of linking to either a particular sheet in the workbook, or named range, my dynamically named range does not show up an being available to link to???? Why not, and is there a work around ??

Thanks,

Joe Dowski
Woodbury, CT. USA.

I have shaded cells and rows on a Excel worksheet, but they do not show up on
the printed copy.

Hello,
My problem is clearly stated in the example below...
Example: I have 50 failure codes that have occurred throughout the
fiscal year, but only 5 to 7 of those 50 codes actually occur every
month. In my macro I have to include all 10 codes because at some point
in the year they will all occur. When I pull by month for the 20 lanes I
am concerned about I want to know a way to only graph the 5-7 failure
codes that occurred that month (not all 50 where there will be some
blanks in the chart/graph).

Previous response:
Tools->Options. Then choose chart tab. I think the chart has to be
selected first
I think you want the "Not Plotted" option

Yes i am currently using that...it is checked but it is still
generating the code as the x-axis when the zero is still not plotted.

I know how to suppress zeros in a graph, but when the zeros are
suppressed how do you make the respective code that is on the x-acis
not show up so that the graph doesnt have these 50 codes on the bottom
and only 5 bars with data. I want the 50 codes to drop to the only 5
that have a populated number so the graph is not huge.

Thanks as always,
Keith P

--
Pfeif0
------------------------------------------------------------------------
Pfeif0's Profile: http://www.excelforum.com/member.php...o&userid=35386
View this thread: http://www.excelforum.com/showthread...hreadid=551618

Hi:

Can anyone please tell me how to make all of the objects in a workbook
show up in the VBA's property window? I have a command button on a
sheet that executes the VBA commands as it should. I can view the
commands so I know its there. For some reason it does not show up in
the VBA properties box. I also believe that There is a user form that
is not showing up as well. Is there a way to get them to show up?

Thank you for any suggestions!

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

Why is it that the last one or two text boxes on an embedded chart do not
display when I click outside the chart area?

I am using 16 text boxes on a chart instead of the legend as it makes it
easier to read. I then select an area that includes the chart and copy it
to Paint (see note 1), where I save it as a JPG as I want to load it onto
the web. The Excel file and the JPG file can be found at the following links

http://mysite.mweb.co.za/residents/l...ph20080705.xls
http://mysite.mweb.co.za/residents/l...ph20080705.JPG

Why is it that the last one or two text boxes do not show up when I click
outside the Chart Area. In the files above the text box "Cyber Voortrekker"
does not show up when I click outside the chart area (nor is it visible in
the JPG image - it is the last pink coloured series at the bottom of the
chart)? I am using Excel 2000. All the text boxes have been entered in the
same way (ie I have ensured that the chart area has been selected so that
the text box is on the embedded chart and not on the spreadsheet).

I am really puzzled by this.

NOTE 1: I find that the definition of the final JPG is better if I select a
spreadsheet area enclosing the chart as opposed to clicking on the chart
itself before the copy/paste to paint. Are the any better ways of creating a
JPG image of an Excel chart?

Many thanks
Laurence


Why is the name that I gave my excel workbook not showing up in the title
bar when i open the workbook? It use to always show up there, but now when I
open a previously saved workbook, there is no name in the title bar.

When using a Macro & Excel's Add In "Solver" the Excel Solver Results do not
show up on 2 computers. The results do show up on one computer that we have.

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

When I use Excel the blue bar (I call it the titla bar) is not showing up.
this is the one to mininize, maxinize ot to close the window. One day it
just didn't show up. What can I do to get it back?

The Excell spreadsheet prints in color, but the highlighed areas do not show
up on screen. Any suggestions about how to fix this?

I had a problem with a worksheet where the formulas were not recalclulating.
I essentially solved it by renaming my worksheet (to SummaryBak) and using a
new worksheet I named Summary. This morning, while changing the codename of
Summary, I noticed that, the worksheet SummaryBak was not showing up in the
VBE (in the window that lists the Projects, probably called Projects window.)

I did a little research on the worksheet, for instance, I checked if it had
somehow become protected. Based on the options, it would seem it hasn't.
If I make that worksheet the active worksheet, and type, from the immediate
window, ? activesheet.name, it says SummaryBak. However, if I type ?
worksheet.codename, I get an error: Runtime error 1004, application defined
....

As far as I know, this isn't causing me any additional problems, but I can't
help wondering if it points to the original problem I was having with not
recalculating. If I weren't such a pack rat, I would have already deleted
this worksheet, as it has been replaced. However, if any one can shed some
light as to what would cause this, I would appreciate a response. Also, if
it is a ticking time bomb waiting to explode, please let me know and I will
delete post haste.

Thanks.
--
Kevin Vaughn

When I use the color cell buttons it does not show up? When I go to print
preview it only shows black and white and not the color I chose?

My Immediate window does not show up at the bottom of my page when I click
onto View/Immediate Window. It now shows up as a full sheet. I went to
Options and it is clicked off as dockable. Don't know what I did. How do I
reset it so that it shows up below my code window.

Thanks

Hi all,

I am pretty new to VBA and am having a problem that is driving me crazy with a public function that I tried to create.

I have a spreadsheet that has several custom public functions (some created by me, some created by other authors). The problem that I am having is that one of the public functions is not showing up when I start to type it in the spreadsheet (i.e., it is not showing up like =sum, or =product are). All the other functions that were created are showing up fine.

The other weird thing about this though, is that I also made another function that references the "missing" function in the VBA. This new function works fine, and seems to be using the "missing" function fine as well.

Is there something that I am missing? I feel like there must be a simple solution to this problem. Below is the code for the "missing" function.

Public Function StrtWeir(Length As Double,
flow As Double) As Double
       StrtWeir = ((flow) / (2.152 * Length)) ^ (2 / 3)
End Function
Thanks for any help and let me know if you need anymore information.

Hello,

I am trying to save my worksheet as a CSV file but it is not showing up on my laptop for some reason. I am running Windows XP with Excel 2007.

On my desktop, it is showing up under the "save as type" selection screen but not on my laptop.

Can anyone help?

Thanks.

I am working with a network server. One person created an excel sheet that
is to be added to by others. She did NOT create it as read only. However,
when SOME people open and save they are told it's read only, yet a small
number of others can open and save with NO problem. When I checked the
properties it is not showing up as read only and when I right click the file
name in explorer and click the general tab there is is not showing as read
only. HELP

Hello,
My problem is clearly stated in the example below...
Example: I have 50 failure codes that have occurred throughout the fiscal year, but only 5 to 7 of those 50 codes actually occur every month. In my macro I have to include all 10 codes because at some point in the year they will all occur. When I pull by month for the 20 lanes I am concerned about I want to know a way to only graph the 5-7 failure codes that occurred that month (not all 50 where there will be some blanks in the chart/graph).

Previous response:
Tools->Options. Then choose chart tab. I think the chart has to be selected first
I think you want the "Not Plotted" option

Yes i am currently using that...it is checked but it is still generating the code as the x-axis when the zero is still not plotted.

I know how to suppress zeros in a graph, but when the zeros are suppressed how do you make the respective code that is on the x-acis not show up so that the graph doesnt have these 50 codes on the bottom and only 5 bars with data. I want the 50 codes to drop to the only 5 that have a populated number so the graph is not huge.

Thanks as always,
Keith P

My data pts do not show up , my scales are right, what gives?

Hi, I'm starting to figure out this Combo Box filter stuff but the problem I'm having is when I right click on the Combo Box to enter the Control tab in the Format Control menu, the Control tab is not there. Does anyone know how to get the Control tab to show up?

Any help would be greatly appreciated... thanks a lot,

AKphidelt

I feel like I am doing something really dumb, but I can't figure out what so hopefully someone can tell me what's going on.

I have successfully created other forms, so I created one this morning with a text box title, an image, and an unbound list box. When I go to open the form in view mode, nothing shows up but a blank screen (or just the background of the form if I have changed the color of it). I have the visible property set to yes and the show up property to always for all the items on the form. This has never happened before so I am not sure what's going on.

In Excel, I have a worksheet where the gridlines are not showing up. I'm not talking about cell borders (which I do not have any of in this worksheet). But I do want the normal light-grey lines to show up when the sheet is viewed on the screen, though no borders are supposed to actually print. In fact, only some of the gridlines are showing up, which really puzzles me.

I went to:
Tools --> Options
View Tab
Window Options category.
The checkbox is clicked for Gridlines, and "Gridlines Color" is set to automatic. (I tried setting it to grey manually, but that only showed up with grey gridlines for the ones that are showing gridlines....but none for the others that aren't.)

I don't understand how one sheet could have some cells with gridlines and some not. None of this affects how the sheet prints (whether it is checked or not), of course. People can print a copy with no problem, but it looks unprofessional in the soft copy.

I have been working with a large file for months now, and have recently
started having this problem. I typically take info from other files and
copy/paste it into my large file to combine. However, for some reason, when
I paste the info into the cells, it now does not appear. I also tried to
copy some of the text from my file on to a blank worksheet, and it doesn't
show up there either. We switched to Vista from XP recently, I don't know if
that has anything to do with it. Its a large document, about 16,000 rows.
Is there a limit?
Thanks for any help you can offer.
Jennette


No luck finding an answer? You could always try Google.