hyperlink excel 2007 backslash Internet Explorer 7
Fri, 30 Apr 2010 07:31:47 -0700 (PDT)
In excel I can create a hyperlink without any problem, byt when I pick
when I wish to open that web page a '/' gets appended to the URL
ex:
in excel
http://someplace:7080/xx
When it gets to IE it is
http://someplace:7080/xx/
the / has been added to the end, there the url will not work. This is
all interna ...
|
error code 0x0000038c
Fri, 30 Apr 2010 13:58:56 +0100
I have recently started to get error codes with both word and excel,
Excel 0x0000038c
Word 0x00000d68
Its all `double dutch` to me what all this means so would I be better to
uninstall office and reinstall to solve this.
Unless there is an easy click on this type fix I am liable to mess even
further.
...
|
Excel formula not updating unless spreadsheet is saved
Thu, 29 Apr 2010 08:36:31 -0700 (PDT)
Hi
I am running a spreadsheet where formulas link into other worksheets
i.e. ='ASSORTMENT SHEET'!N23.
I have noticed that when I update the cell reference above, the linked
cell does not update automatically and only updates when I click
save.
I have since tested a new spreadsheet up, set up a linked cel ...
|
Excel 2007 Sharing Violation when saving a workbook with a passwor
Thu, 29 Apr 2010 07:08:01 -0700
In the last few days, one spreadsheet will not save changes. Message is that
there is a sharing violation.
The spreadsheet is protected by a password to open it. When I remove this
password it saves OK.
Password is set/unset by clicking Office button then Prepare then encrypt.
but can also be set/unset b ...
|
Using VBA to change the contextual menus
Thu, 29 Apr 2010 05:38:26 -0700 (PDT)
Hi,
I've cobbled together the following two scripts to change how the
contextual menus look but I get a 'Run Time Error '5': Invalid
procedure call or arguement'. When I debug it points to the line:
Application.CommandBars("Cell").Controls("Insert...").Delete
If I comment this line out the script wor ...
|
Graphing only certain columns
Thu, 29 Apr 2010 03:01:03 -0700 (PDT)
I have a sheet with some summarised data on it and a column graph of
one of the rows. I would like to have a row that has a boolean of some
kind indicating whether or not to graph that column's data and have
the graph automatically include it or not without me manually having
to edit the source data for the grap ...
|
Array problem. Comparing data.
Thu, 29 Apr 2010 00:23:00 -0700 (PDT)
Hey,
Let me set up what I'm trying to do. I have 3 columns with the
following data.
A: 10, 20, 30
B: X, Y, Z
C: 28, 8, 1
Now, I have a last column, D, which I'm trying to figure out the
correct formula for.
I want D to return the following:
Look at column A, find the smallest number that's greater t ...
|
|
|
auto refresh
Thu, 29 Apr 2010 08:11:48 +0100
Is it possible to open a spreadsheet, refresh linked data then save the
spreadsheet automaticaly at a set time each day?
any help would be appreciated
Mike
...
|
Combining functions
Wed, 28 Apr 2010 22:30:53 -0700 (PDT)
I have a spreadsheet with two functions that looks like this:
A B C D
ID * = Dupes DATE *** = 2 weeks apart
00020AS 9/04/09
00057ST 9/03/09
00072TW 11/02/09 ***
00102IP 4/10/09
00133GY 15/10/09 ***
00204GC 23/11/09
00283RL 3/09/09 ***
00330NO 30/12/09
00 ...
|
When I Select More Than One Tab - Excel 2007
Wed, 28 Apr 2010 15:20:51 -0400
Is there a way for Excel to tell me when I have more than one tab selected?
Other than me remembering to look at the top and see [Group] in the file
name.
Any ideas are welcome!
(B^>)-]=[
...
|
