|
error messages
I had the error message...
> cannot SKU011.cab I soved this by following the instructions listed here.
>
http://social.msdn.microsoft.com/en-US/Profile/?referrer=http%3a%2f%2fsocial.msdn.microsoft.com%2fForums%2fen-US%2fvssetup%2fthread%2f5493e068-01d3-4e96-a9b1-58020bc94e69%2f&rh=YI7rGXc4iv4rR%2b2JUZeQQv4OEnxWySPD0w%2bJjbDQwzE%3d
> Then I received the error message...
> 1311 sou...
|
1 |
12/21/2008 1:02:54 AM |
|
|
#REF when deleting cells
Hi...
I have a spreadsheet importing data from another spreadsheet in the same
workbook.
Upon deleting cells with the original data in the second spreadsheet, linked
cells in the first get their values destroyed when a #REF is inserted into
the formula.
Is there a way to stop this?
The cells in the originating spreadsheet do not change their references.
They're still named A1, A2...
|
14 |
12/20/2008 11:31:12 PM |
|
|
Search Microsoft Excel Newsgroups
Hi,
I've lost my link (url) that I used before to search Microsoft Excel
newsgroups. I believe it was a link to a Google search page that
automatically populated certain fields so that only Microsoft Excel
newsgroups would be searched.
Does anyone have that link or something similar that would allow me to
efficiently search the newsgroups?
Thank you.
Kevin
...
|
6 |
12/20/2008 10:53:15 PM |
|
|
Excel 2003 - Parsing
I have figured out several ways of doing this, but would like to know if
anyone knows of a way to do it with a single formula. The reason for this is
the large amount of data does not make breaking it down with macros very
practrical from a time-cost viewpoint.
I have the result of a query in a cell. The result contains seven variable
length varibles, separated by commas. I would like to ge...
|
9 |
12/20/2008 8:16:57 PM |
|
|
Split text
Hi,
I have a list with credit ratings from which a lot are extended with /*
+ or /*-, as these are confusing I would like to delete them.
My question is if there is a formula to exclude these signs from the
actual rating. For example: AA- /*- needs to become AA-
Thanks
Regards,
Robert...
|
6 |
12/20/2008 7:05:00 PM |
|
|
Generate list based on multiple criteria
I am trying to count the number of unique invoice numbers. However, if
the invoice number has debits and credits I have to go through and
match the debits and the credits. If the total amount is zero, the
invoice number cannot be included in the original count. An example of
an invoice number that will need to be removed from my count is the
last one in the example list.
I was using this f...
|
2 |
12/20/2008 6:17:01 PM |
|
|
Accidentally deleted right click menu.
Hello,
I have this little problem - when creating macro, I accidentally
deleted right click menu - that is I deleted all the positions from
the menu. Now it is deleted in all spreadsheets - I even rebooted and
it is still missing:)
The question is - can I restore it? How?
Will be glad for any help,
Mike....
|
2 |
12/20/2008 12:16:00 PM |
|
|
Run VBA without show
I want excel to run the VBA code without showing me what it is doing.
Which code should i use for that?...
|
3 |
12/20/2008 3:36:41 AM |
|
|
Excel 2003 - VBA - More querys
I cannot find a solution here and I cannot be the first person that has run
a query, then needed to know how may elements are in the result.
I do a query and count the elements. The count is wrong since the data is
not there yet.
I tried to add a timer delay after the query but before the count. The data
isn't presented until after the timer expires (no matter how long the timer)
I tri...
|
2 |
12/19/2008 6:46:17 PM |
|
|
Moving data using macros
Hi All
I am attempting to compile a number of lists from a daily report I get.
What I would ideally like is just to cut the page into excel, run one macro
and all the relevant lists be put on seperate pages.
The question I have is how do you get a macro to look for the first
available blank rom. i.e. How do you tell the macro to put the data
underneath the one it did yesterday (if ...
|
3 |
12/19/2008 4:57:01 PM |
|
|
Automatically Update Pivot Charts
Hi there,
I've got one sheet in a large workbook (Excel 2003) that is made up of Pivot
Charts. I would like for those charts to be updated everytime the sheet is
opened within the book. I think a macro would probably be best (but please
tell me otherwise if you know another method!) and am using the below code
but there are a few difficulties:
It's meant to update all the pivot tab...
|
5 |
12/19/2008 4:42:06 PM |
|
|
Excel 2003 documents migration to 2007
Hello Excel Mania.... :)
I have project to convert a lot of Excel 2003 documents to Excel 2007,
including its macro and chart.
After I surfed some website which mostly got explanation about changes
between thoose version, I hardly find a complete explanation to deal with
this problem, I mean the straight bold explanation to convert, not only to
analyze the differences.
Any advise...
|
7 |
12/19/2008 3:47:43 PM |
|
|
Excel 2003 - VBA - .copy
I want to copy a range from one page to another. I seem that I have to have
the sheet that I am copying from as the activesheet.
Sheets("Display").Select
Sheets("PPO").Range(Cells(3, 2), Cells(3, NumSym + 1)).Copy
Sheets("Param").Cells(3, 2).PasteSpecial Paste:=xlPasteValues,
Transpose:=True
The above will fail.
Sheets("PPO").Select
Sheets("PPO").Range(Cells(3, 2)...
|
4 |
12/19/2008 3:27:59 PM |
|
|
Accidentally deleted right click menu.
Hello,
I have this little problem - when creating macro, I accidentally
deleted right click menu - that is I deleted all the positions from
the menu. Now it is deleted in all spreadsheets - I even rebooted and
it is still missing:)
The question is - can I restore it? How?
Will be glad for any help,
Mike....
|
2 |
12/19/2008 2:50:05 PM |
|
|
problem with saving
When I tried to save a changed file, I got error: "could not save because of
sharing violation."
Never saw this before. So I had to save to a new file name.
...
|
2 |
12/19/2008 9:09:16 AM |
|
|
Range Naming Problems
Let me try this again.
I need some expert help.
I'm a battering VBA coder (beginner).
How would I make the Sheet Name dynamic for this formula? I need to
type the name of the sheet (Mask or any other name) in a cell, say A1,
and the VBA code below ( I found it on the code here:
http://www.microsoft.com/office/community/en-us/wizard.mspx?dg=microsoft.public.excel.misc&tid=9929481c-550f-4c81-a...
|
4 |
12/19/2008 9:04:01 AM |
|
|
Converting Excel with Word
Hi to everyone.
I have a table in an Excel sheet. In every row of the table included some
information’s of a number of persons (Name, address, age, work hours,
distance, etc)
I also have a doc file in Word, which i use it like a form, to connect the
above information’s in some points in the doc.
I would like to convert somehow the Excel table to word doc applying 2
conditions.
a)...
|
2 |
12/19/2008 8:46:13 AM |
|
|
View Menu is invisible
Hi,
My Excel does not show "View" on the Menu Bar. Can somebody help me in
making my Excel's View Menu visible.
Regards,
Ajay Varshney...
|
5 |
12/19/2008 8:33:55 AM |
|
|
Topics on Electronics
Electronics is the field of manipulating electrical currents and
voltages using passive and active components that are connected
together to create circuits. Electronic circuits range from a simple
load resistor that converts a current to a voltage, to computer
central-processing units (CPUs) that can contain more than a million
transistors. The following indices and documents provide a basic...
|
1 |
12/19/2008 8:09:19 AM |
|
|
Topics on Electronics
Electronics is the field of manipulating electrical currents and
voltages using passive and active components that are connected
together to create circuits. Electronic circuits range from a simple
load resistor that converts a current to a voltage, to computer
central-processing units (CPUs) that can contain more than a million
transistors. The following indices and documents provide a basic...
|
1 |
12/19/2008 8:08:27 AM |
|
|
Unable to open Excel 2007 due to "virus scanning"
Hi all as a little help would be appreciated. I was working with Excel 2007
just fine at home, but now I am unable to open my excel documents as I keep
having to enable these files from the disabled files due to the error message
of "the system encountered a problem when previously opening...." Now when I
try to open them, I see that "scanning for virus" is in progress on the lower
lef...
|
1 |
12/19/2008 6:56:00 AM |
|
|
resize edit links Dialogue Box in Excel 2007
I am using Excel 2007 and wish to resize edit links Dialogue Box when there
are multiple links to edit. Not able to do so unlike in Excel 2003.
Is this is any limitation in Excel 2007 for this particular feature.
Example if we have more than 80+ files which are linked and we cannot edit
the links.
Please let me the workaround....
|
1 |
12/19/2008 6:34:00 AM |
|
|
Excel 2003 - VBA - Querys
I have a procedure that sets up a bunch of querys and then uses the data in
the first query to parse out the dates. If I breakpoint the operations
following the querys and wait until they have finished, all works properly.
But if I pull the breakpoint so the procedure places formulas into the sheet
that uses the query data, it puts some of the subsequent formulas in the
wrong cells.
Setup ...
|
1 |
12/18/2008 10:21:48 PM |
|
|
Conditional formatting
How can I apply a conditional format to a cell whenever 2 conditions are met?
Let's say, for example, I want cell A1 to be colored red if cells A3="Yes"
and A6<>0. But only if both are met, otherwise color it green.
Thank you....
|
3 |
12/18/2008 9:34:28 PM |
|
|
Pivot Tables - Unique items
Hello,
I run into a situation i dont know how to solve. The source table looks like
this;
WKSNAME,OS,APPLICATION
WKS0001,XP,Excel
WKS0001,XP,Word
WKS0001,XP,Powerpoint
WKS0002,Vista,Word
WKS0002,Vista,Excel
WKS0003,XP,Outlook
I'd like to count the number of XP workstations by using a pivot table.
like this:
OS "count of WKSNAME"
XP 2
Vista 1
The problem i run into is...
|
3 |
12/18/2008 8:44:57 PM |