There is one user who accesses excel spreadsheets via a network share who often gets error message: "filename.xls is locked for editing by the username(its the user themselves) click to notify...
I have a client who has requested an Excel.xls file to be password protected when opened. This file contains confidential information so when the user attempts to open the file they would like...
I am looking for a utility that is similar to printing to PDF like adobe acrobat.
BUT.... what I really need is a utility that will allow me to print from the web (a table) directly to an ...
I get this error when trying to save or close an excel spreadsheet that gets data from another open spreadsheet.
Excel cannot complete this task with available resou...
I have a notepad that I want to convert into excel. The notepad is structured in this way,
Page 1
Field Description Pos ...
I haven't done a whole lot with Excels formulas and am not sure if this can be done.
I have this formula in an Excel cell: L57=(L51*L53)+L55
What I want to have happen is that if the S...
The toolbar that shows the Sheet Tabs in Excel 2007 at the bottom is gone. How do I get Excel to show Sheet Tabs.
I want to find the position of a cell in the range A1:A100 based on the value of the cell using the MATCH function in VBA. I always get an error message. Based on examples I have seen, the s...
I'm exporting a tab delimited file, but I notice that Excel wraps quotes around fields that have a comma, and fields that have quotes.
Is there a way to prevent this and just get the raw da...
I can't figure out how to format the formula to use RC notation, so that an existing column of text entries can be formated based on the contents of an existing cell set of one to the right.
Hi,
In excel, how can I use the Formula SUMIF(range, criteria, [sum_range]) to sum if NOT EQUAL to some text.
=SUMIF(A4:C4:, <> "Ops", A5:C5) does not seem to work.
Angus
If I recall., it's around 64,000. Anybody know?
And is there a way to increase this number?
thanks,
newbieweb
Hello
How to stop Excel 2007 .creating backup files .xlk files
Earlier I posted a question on how to find partial text within a specified range. The solution that was given was to use:
[quote][b][u]zorvek:[/b][u]
=VLOOKUP(Z1&"*",A1:B14,2,FALSE)
Wh...
I am using Excel 2007 and am having a problem saving as 2003 with a specific file. The file is in 2003 format. I am able to open the file. I can save the file as 2007 but it needs to be in ...
Excel 2003 requires the user to enable macros before being able to access or use the workbook.
Excel 2007 allows the user to use the workbook without enabling macros. Macros can be enabl...
Hello Everybody,
Microsoft Excel crashes every time I close it... I've attached a screen shot of the error signature. I need to find a way to fix this without reinstalling Office or Excel.
...
I am interested in programatically selecting an entire row in Excel, so that it is clear that it is selected. It is important that when a user types to edit, the originally clicked cell is the...
Here's my class module:
== Original Class Module ==
Option Explicit
Private m_parts(4) As String
When I compile it, I get this error:
"Compile error:
Constants, fixed-lengths, ...
I've got a database where I'm trying to get all the names that are linked to an order, usually there are multiple names to each order.
Example Data Table
Order# Cust# Title Slsprsn CntctT...
Hi Experts
I am using the macro below to format and juggle a sheet including merging 2 cells into 1 on each row.
However, the sheet I am using has x amount of rows and I need to carry ou...
I am not able to convert a number greater than 24 into h:m:s
I use the formula =(H5/24;"hh:mm:ss") but this only works up to 24.
When I try this with 27.50, the result is 03:30:00 because ...
Hello,
This must be easy but I stuck...
I have a macro and it should check if 2 conditions are fulfiled and if so - run rest of insructions. Please have a look what I'm doing wrong.
My ...
Experts,
I want to understand how to use a radio button in Excel/VBA.
I want it so that if I select a radio button the contents of a cell changes according to the code. For example from ...
Is there a excel spreadsheet function that can be used to interpolate between two columns of data? If not, can you recommend a quick equation to perform interpolation?
