Significant Loss of Functionality
Thu, 24 Jul 2008 04:19:00 -0700
I'm writing a tool to be used by inexperienced users in 2003 without
intervention. I'm using 2007 and saving down. A compatibility error has
arisen, which seems to go away and then resurface, which relates to numbers
of rows and columns. However I'm nowhere near the limits.
I opened the file on another PC ...
|
Help with copying merged cells
Wed, 23 Jul 2008 11:50:01 -0700
I am trying to copy information from one merged cell on a worksheet into
another merged cell in a different worksheet. The one that we are copying
from is the same size as the one we are copying to, but we still get the
error that they have to be the identical size in order to copy. I have
played around wi ...
|
vlookup returns the formula I entered, not the expected value
Wed, 23 Jul 2008 10:19:01 -0700
Hello,
My vlookup formula "=VLOOKUP(A1,'src-data'!$A$1:$F$5,6,FALSE)" and/or
"=VLOOKUP(A1,'src-data'!$A$1:$F$5,6)"", when applied to some columns, is
returning the formula I entered. It is not returning the desired value.
I have an XLS with two worksheets. One includes the source data (src-data).
The ot ...
|
Excel worksheet won't open.
Wed, 23 Jul 2008 09:36:12 -0700
I am trying to open an excel documment that will not open, it is a xsls
extention i believe. all i get when i open the program is those wonderful
symbols throughout the page.
--
all help and sugestions will be accepted. ...
|
Cannot open userform
Tue, 22 Jul 2008 16:53:03 -0700
Hi
I had a subroutine that opens a userform as shown below and it was working
fine:
Sub OpenUserForm ()
UserForm1.Show
End Sub
But after I worked on others codes last night, the subroutine now cannot
open the userform due to:
"Run-time error '-2147024809(80070057)': Could not find the specified object. ...
|
Edit commands not available
Tue, 22 Jul 2008 08:01:01 -0700
I have Excel 2003, SP3 on a laptop. For some time now, the "Cut" "Copy"
"Paste" "Paste Special" commands that I use often are grayed out (not
available). How do I solve this problem? ...
|
Excel crashes when copying a cell
Tue, 22 Jul 2008 00:12:03 -0700
I have 220 entries in a worksheet. When I copy a cell down the list Excel
crashes. Does anyone have a suggestion to help please. Copying a few at a
time doesn't work either.
--
Sandra ...
|
|
|
CANNOT INSERT COLUMN AFTER DELETING ALL BLANK CELLS
Mon, 21 Jul 2008 14:05:01 -0700
I am Editing multiple worksheets that were created previously. I entered
formulas (every 3rd row) in the final "TOTAL" column, & set the Print Area
just for my active cells. I got the message about CTRL+END...& Delete Blank
Cells...bla bla bla. I did this & on one smaller worksheet it worked
great!!!! Yet o ...
|
Linked tables do not restart,when you re-open them
Mon, 21 Jul 2008 12:58:04 -0700
I am working on an Access database that has linked tables in the 'front'
(Production folder) and 'backend' (Maintenance folder) on a network. When I
close the Access databases down, the same linked table in the (Maintenance
folder) is gone. The linked table in the (Production folder) is still there,
and natu ...
|
Saving Files
Mon, 21 Jul 2008 07:55:01 -0700
I am using Excel 2007. When I open a 97-2003 file and do save-as, I get a
message that the file is in use by another user. This does not occur
everytime, but often. I have to save it as a new name. It is on a shared
server, most other users do not have 2007 yet. Changing the name is not the
best option, ...
|
