i cannot use the mouse right click in excel. how to rectify?
i cannot use the mouse right click in excel. how to rectify?
Is this just when over the cells ?
Does it work on the title bar - windows options
Or on the Excel menus ?
On Tue, 19 Sep 2006 14:21:01 +0100, j <email@example.com> wrot=
> i cannot use the mouse right click in excel. how to rectify?
Unless the right-click button is frozen, I'm sure you can use the mouse
right-click in Excel
Just hit the right-click button.
Now...........................the real issue
What are you right-clicking on and what doesn't happen for you?
Does the right-click no...linking cells #3
I have a calendar created in Excel - each sheet is a new
month that contains the following information: the last
week of the previous month, the current month, and the
first week of the next month. I would like to link the
cells from the "overlapping" weeks, but I do not want
the "0" to show up in the cells. Is there any way to
prevent this? Thanks in advance!
Either choose not to show zero values through Tools>Options>View or trap the
zero and turn to a blank-looking character.
Gord Dibben Excel M...import hyperterminal value into excel
How do I import a hyperterminal value into an excel cell?
...Excel Function to Access
I would like this excel function =IF(A4=A5,C5-C4,C5) to be utilized a
a function in a query in MS Access where the fields that supposed t
be in column A are the primary key fields and the next fields whic
are in column C, are to be calculated in.The answers to this functio
are to go into a new field.....Any help please? :
Primary key, by definition, means no duplicates. How would A4 ever equal A5?
Remove 'Junk' from return address.
"CJT" <firstname.lastname@example.org> wrote in message
&g...Is it possible to have 2 excel version in one computer?
i just installed a 2003 version office... i liked the new features but
when i wanted to open an excel file that has been created by 2002
version excel, i was shocked that i can't open the file successfully.
When i opened and enabled the built in macros in the file, an error
message popped out and said that the data may have been lost. After I
have closed the error message, i checked the file. the data is still in
the worksheet but all the words, format, buttons, and other information
have all disappeared. However, if I open it in another version other
than 2003, the file work...Free MS Excel/Access Video Tutorials and Articles
There are a whole bunch of free articles and video tutorials at
http://www.davidbase.com. There's no cost to sign up and there are
lots of articles and videos to check out.
Some of the topics are Access VBA, Excel, Database Design, Reporting,
Union Queries and more.
Some recent articles:
Access Parameter Queries
Excel VBA Random Numbers
Relationships and Joins
� and plenty more.
Sign up (it's free) right on the home page and see if it suits you.
...Excel Formulae #3
I have a spreadsheet with value in one column & a series of dates in 5
other columns.For each row depending on the value
in the first colunm a date may be applicable in one or more of the
other columns.e.g 550 in the first column will mean dates will be
inserted in the next 2 columns similar to authority levels. My qn. is
how can I show what's outstanding if the relevant authority levels have
not signed off-basically this is used as a tracker of invoices & I
would like to show what is outstanding awaiting approval at anytime.
----------------------------------...Excel -- Wrapped text disappears
A user here is having the same problem as described in a previous topic
Windows XP Pro, SP2
Office 2003 Pro, SP2
New machine with plenty of resources.
Was originally working properly, then mysteriously developed a strange
Any text that is in an Excel cell in which the "wrap text" option has
been selected no longer shows up. I have checked it with 1 character,
1 word, and multiple lines of text. It has been repeated with
spreadsheets created on...EXCEL caused an invalid page fault #3
Whenever I start EXCEL 2000 I get the following msg.
EXCEL caused an invalid page fault in
module EXCEL.EXE at 018f:3001de79.
EAX=900a0154 CS=018f EIP=3001de79 EFLGS=00010246
EBX=00100000 SS=0197 ESP=0062eb5c EBP=0062ebf0
ECX=0000c630 DS=0197 ESI=50020044 FS=0ebf
EDX=30021a90 ES=0197 EDI=300378d4 GS=0000
Bytes at CS:EIP:
0f bf 04 c5 aa df 01 30 89 45 dc 8d 45 e4 50 e8
50020044 006b76e4 006b7608 006b7608 0062ebf0 006b7608 006b76e4 006b7608
0062eb54 3001dcc3 00000000 bff728a2 bff54f53 1294bb9c ad4c17af 12990002
I had reinstalled and repaired several times but it does n...Bug in excel 2003
I'm trying to get an equation of a table of data.
When I enter the data, make a graph of it, I get a nice sinus-kind-of-line.
Therefor I would like to have fourth order equation.
The line of data looks very good (125 data points).
Then I add a trendline (4th order) that looks like a very nice fit.
But when I set the properties of the trendline to "show equation in graph"
the a wrong equation is displayed.
After a lot of fiddling with data, I noticed that the shown equation has
wrong contstands showing.
The shown eqaution = A + B*X + C*X^2 + D*X^3 + E*X^4
In fact ...where can I find a nurse staffing templatew for excel 2000
I need an excel template for excel 2000 that would allow me to staff nurses
Try the Office Template Gallery.
Gord Dibben MS Excel MVP
On Mon, 17 Mar 2008 17:54:00 -0700, klif_e <email@example.com>
>I need an excel template for excel 2000 that would allow me to staff nurses
...Excel 2007 Back-up copies
How do I stop Excel from creating a "back-up" copy everytime I "save" a
document? It only does this when I "Save" not when I "save as". My folders
are quickly filling up with back-ups. This just started happening after I
upgraded to Windows 7.
Does that happen for all workbooks or a specific one.
Open the workbook>from Save AS dialog>Tools>General Options> check whether
'Always create backup' is enabled or not?
If this post helps click Yes
"Hawaiianshirt...Time formats in Excel 2003
Being in the UK, I obviously want to use the English(UK) date format, so
Christmas Day is 25/12/05 rather than 12/25/05. However, this defaults
the time format to hh/mm/ss (why, I do not know, since I can assure
American readers we're not normally that precise), so I have to reset it
English(US) to get hh/mm, which resets the default date format to
mm/dd/yy, so I have to change it back the next time I want to format a
cell as a date.
Any way round this? It's only a minor problem but it's irritating me.
If you set up your own custom format with hh/mm, it w...excel passwords #2
I need to know how to set up a password and change a
password to prevent access to my workbook.TIA
Use workbook/sheet protection.
Select tools menu>protection. There you can select the
type of protection you want and include a password
>I need to know how to set up a password and change a
>password to prevent access to my workbook.TIA
...Excel 2003, when I click on a particular cell it gets deselected
While using Excel 2003, when I click on a particular cell, within 30 seconds,
that particular cell gets deselected followed by the workbook. So each time I
need to click either the cell or workbook to enter data in that particular
There could be event code that is being fired. Does this happen if you open the workbook with
MS Excel MVP
"towinwin" <firstname.lastname@example.org> wrote in message
> While using Excel 2003, when I click on a particular cell, within 30 se...Reading Registry Key through excel?
Is there anyway to read a certain registry key and display it in a cell
how about a way to create a key through excel? is that possible
Message posted from http://www.ExcelForum.com
There is a special registry area for VBA which is read/written via
GetSettinmg and SaveSetting functions.
It is a bit restrictive, in that in can only writes to a limited part of the
registry, but it's sufficient for storing application details.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"ravz &g...Filter List for Linked Values
I have a list of Numbers. In that list some Cells are:
- Linked Values [ e.g. ='[Sales.xls]Sheet1'!K61) ]
- Forumlas [ e.g. =1802+254+356 or =sum(A2:B32) ]
- Manually Entered
I want to filter the list for linked values. Is this possible?
not without VBA (using a user defined function) and a
>I have a list of Numbers. In that list some Cells are:
> - Linked Values [ e.g. ='[Sales.xls]Sheet1'!K61) ]
> - Forumlas [ e.g. =1802+254+356 or =sum(A2:B32) ]
> - Manually Entered
> I want to filter the l...'Ghost' Link In Workbook
Sometimes, when I open a workbook, I get a window telling me that th
book has an outside link to another book, though I'm not aware o
having linked it. A search for the link turns up nothing, an
sometimes - Even if I delete the contents of the entire sheet - Th
link still shows up under the 'Edit' menu. It is _extremely
frustrating!!! Any feedback on this would be appreciated
bohnneville's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1560
View this thread: http:...how do I unblock links in email mesages received in Outlook?
LInks in emails in Outlook are blocked-they will not iopen
What happens when you try? A common error begins 'restrictions in effect...
' - for this problem, see http://slipstick.me/restrict
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
Poll: What version of Outlook do you us...Sharepoint CRM Web Part
I'm having problems getting the CRM 3.0 web part working in Sharepoint
and I suspect that it's to do with my configuration:
I run Sharepoint on an SBS 2003 box and CRM 3.0 on a seperate 2003
In the AD I've set the Sharepoint SBS box to allow delegation, however
as this is SBS, you can't specifiy whether or not to use Kerberos
Has anyone got it working using this type of setup before?
I noticed web part is built on top of FilteredViews, and it has similar
Kerberos delegation requirement.
You may want to check out the KB we have for repo...SSL Sending via IMAP Configuration?
I'm trying to configure Exchange2003 to be able to send emails from
outside IPs using IMAP with SSL. I can receive IMAP mail over SSL no
problem. I don't want to use any VPNs for this if possible.
Has anyone have any Exchange configuration settings to allow outside
IP's (like home users DSL) to be able to send IMAP email over SSL?
Ed <email@example.com> wrote:
>I'm trying to configure Exchange2003 to be able to send emails from
>outside IPs using IMAP with SSL. I can receive IMAP mail over SSL no
>problem. I don't want to use any VPNs for this if pos...excel find problems
I have a database in excel with 4 sheets.
When I want to conduct a search, it only searches the active sheet.
Therefore I have to select each sepearte sheet and carry out 4 individual
Is there any way to search all sheets at once?
If there is not, I am aware I can create a user form and use the approproate
syntax to conduct my required search. However this will take me a long time.
If there is an easier apprach then please let me know.
What version of excel? How are you searching? In later versions of
Excel, you can select multiple sheets and have Edit|Fin...Excell won't open
I have produced a series of spreadsheets this morning. (Excel 2003) on
Have been saving them on a shared network folder.
I have come to open them again and all I get is a the excel background
with no worksheet.
They all opened fine earlier this morning.
Every other machine on the network can open the spreadsheets (from
this location) just fine.
I can open other spreadsheets from that same folder that I produced on
If I copy this morning's spreadsheets to my laptop, they still won't
In all other aspects Excel works fine.
If I save a new workshee...Linking Report into CRM 3
I'm using CRM3, SQL Server 2005 and VS 2005.
I have created a Report Project in VS2005.
I have one shared data source, and 5 reports. Actually, I have 1 report
containing 4 sub reports.
My main report use a parameter (the ticket number) and each subreports
use it too.
Everything works very well in VS2005.
I push everything onto my report server.
And here begin my questions... :)
Onto my SQL Report Server, VS2005 has created a folder with all items.
Question 1 : Is it possible to say in VS2005 to push everything into
the report folder of crm?
I have moved all my items into the C...Mailing labels with Excel
Can I use Excel to print mailing labels? If so, how. Please help, my boss
is ready to strangle me.
"=?Utf-8?B?d3poNTU=?=" <firstname.lastname@example.org> wrote in
> Can I use Excel to print mailing labels? If so, how. Please help, my
> boss is ready to strangle me.
Use Excel as a database for labels in Word. That would be the quickest
solution, I suppose.
It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
Use excel to hold your data and MSWord to print the labels.