Links error when insert line/row to source workbook
I have a question regarding links on Microsoft Excel 2003.
If I insert a line into the source spreadsheet, the link on the destination
spreadsheet doesn't work anymore because the cells moved.
On the destination spreadsheet, the link is =[ACME.xls]Sheet1'!A1
But if I insert a line on ACME.xls, making the info in cell A1 move down to
A2, the link on the destination spreadsheet still pulls from cell A1.
How do I ensure that when I insert/delete lines/row, the link still pulls
info from the correct cell?
If you have the workbook with the fo...H E L P * * * Need help with question about protecting a range of cell in workbook
I need to know how to protect a range of cell/s in a workbook
...input box upon workbook open
I want to have an input box that will ask for a date when a workbook is
I want to be able to us the date that is input in code that will be run
from a macro.
The reason I want the input box upon open instead of when the macro is
run, is because the end user uses the file repeatedly for multiple
calculations. This date will be applied to all of the calculations,
and I don't want the user to have to enter the same date over and over.
I assume that I need something like a "public enddate as date" in the
This however doesn't work. What do I need ...Formula copying from one workbook to another...
Hello Excel community friends.
Here's my problem: I trying to copy a formula from a
worksheet in one workbook to a worksheet (of the same name
and same cell location) in another workbook.
Say the formula from workbook1/worksheet1 is =sum(1+1) and
the name of workbook1 is "Me" and the name of the
worksheet1 is "Sheet1" and located in cell A1.
Of course, when you copy the formula from "Me" to another
workbook (named, say, "You") and to the same location (A1)
and on the same named worksheet, "Sheet1", the preface of
the formula is s...How to prevent any one from opening my workbook
I created a personal data workbook stored in my company network. I do not
want any one in the office to be able to open it and read it.
The "Protect" feature under the Tools does NOT prevent someone from opening
and reading the data (unless I am doing something wrong!).
If they are smarter than the "average aggie" they will be able to open it,
no matter what you do.
"MMCM" <MMCM@discussions.microsoft.com> wrote in message
>I creat...My password don't work on my MS Money 2004 Business edition
I am panicing.My Microsoft Money Small Business Edition password is not
working. Somehow my password changed. All my business data and personal
financial data is on there and i don't know what to do. About two days my
password does not work. I did not change anything. I wanted to print an
invoice and it wouldn't allow me to. It would not allow me to go further
without a password. Is there a solution to this problem or I am just doomed.
Please do a search... if you did a very little
superficial search, you will notice MANY people having
the same problem.
>-----Or...Error message with copying sheet to another workbook
I always encounter an error message when i copy a sheet from one workbook to
The error message is as below:
A formula or sheet you want to move or copy contains the name
'____123graph_A', which already exists on the destination worksheet. Do you
want to use this version of the name?
- to use the name as defined in the destination sheet, click Yes
- to rename the range referred to the formula or worksheet, click No, and
enter a new name in the Name Conflict dialog box.
I have tried to click No and enter a new Name, but afterward...Slow to Open, Small Workbook <2MB, HTML Paste, VBA procedures
I have a small Excel 2003 workbook 1,300kb that takes 3 to 5 minutes to open.
It was created in 2006 and has been opened daily since then.
One sheet in the book is overwritten each morning with a paste from a web
That one sheet has litterly thousands of VBA procedures like the one below
(No code just the Sub - end sub). They must be being created automatically
from the html paste each morning.
Private Sub HTMLHidden999_Click()
I suspect upon open, VBA is inspecting and compiling each sub causing the
slow to open problem.
1) Am I correct?...Sharing a Workbook
We are running Excel 2003 on various XP computers on a peer-to-peer network.
We do not have Windows 2003 server or sharepoint.
- How do we set up an Excel workbook so that two people can work on it at
the same time?
- Do we need Sharepoint, and if so can we install Sharepoint on an XP PC
without having a Windows 2003 server?
Thanks in advance.
Posted via a free Usenet account from http://www.teranews.com
You can set up a workbook as shared, within Excel. I'm not sure how solid it is -- there
have been some issues raised here and there. It lets multi...Excel 2000 Workbook close button hides instead of close
We received an excel file in email. When we click the Workbook close
button (the X) it hides the work book instead of closing it. When we
unhide it, something changes and the close button works as normal, but
we are asked to save changes even if we don't make any.
Looks like there is some code in the background doing something or other.
I'd check the workbook code, particulary the Workbook_BeforeClose event.
It is more likely some code or functions are changing the worksheet contents
than a bug in Excel.
"Steven Robinson" &...Keeping 2 Excel workbooks open at the same time
I was able to have 2 workbooks open at the same time on a wide screen laptop,
and somehow my settings must have gotten modified. Now I can only open 1
workbook at a time. Each time that I attempt to open a 2nd one, the first one
is minimized. How do I correct this?
Thanks for your help
How about just window|Arrange|Tiled (or whatever you want)
> I was able to have 2 workbooks open at the same time on a wide screen laptop,
> and somehow my settings must have gotten modified. Now I can only open 1
> workbook at a time. Each time that I attempt to open a...Win 7 UAC and Passwords
About to take delivery of a new Win7 box and I'm curious about assigning
I found this page
Which includes an interesting paragraph
Curiously enough, it's not always necessary to have a password on an
account. Since an account with a blank password cannot be accessed over the
network, you can substantially reduce the attack surface of a machine this
But this requires that you have good control of physical security over the
machine: if there are users on the machine (or in the environment) who are ...Problem making versions of a table by changing sourse data in another workbook
How to make a version of a table by changing source data in another workbook
and retain original version of the table easily? I lose the original version
of the table if I change the source data in the other workbook even if I
make a copy of the original table workbook. I have to recreate all links if
I make copies of the original table workbook and the source workbook.
Have you tried making a "snapshot" of the worksheet? (Converting the
formulae into their values - fixed forever - using copy/paste special
Just don't do it unless you have a secure copy ...launching excel icon results in not opening workbook
when I launch excel thru a file in my documents, I get a new workbook, but
when I open the file from within escel it works. Also when I launch by
clicking an attached outlook excel file it does not launch (file not found
message). Does anyone have any idea what is going on here?
Sometimes one of these works:
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close Excel and
Windows Start Button|Run
Windows Start Button|Run
The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults....Listing linked workbooks
My workbook contains many links to external workbooks (about 20) maintained by others in my group. Each of the external workbooks gets updated monthly, and renamed. I manually change links as the new workbooks are posted.
I'm looking for a way to list the current filename of all of the external workbooks so that users can which version of the external files are being used.
I've tried using the cell("filename",reference) function, but this only works when the external workbooks are open. Once they are closed, the formula gives #NA. I have also played around with the Link F...SELECT INTO Password protected db
I have a situation where I need to copy a lot of records as is, time stamp
and all, from one database to another database. The problem is that both
databases are password protected. I can send the password to one of the two
in the connection string, but I'm at a loss on how to send the password to
the other database.
...Can I get Outlook 2003 to automatically respond to a Password requ
My issue is with e-mail and Outlook 2003 intermittently showing a dialog box
asking for a particular POP3 accounts Password. I know this is a problem with
my ISP’s POP3 server not getting authentication from its auth server when it
gets busy, I have verified this with Ethereal traces. The problem is the next
mail check will most likely work only if I can get it to check automatically.
The problem is the requires human intervention to click OK in the password
request box. This is particularly a problem when away; first my PC is not
pulling e-mails off my POP server causing me to possibl...Linking Multiple Workbooks #2
I have 40 different workbooks representing the sales for 40 differen
regions. Each region has identical spreadsheets. I want to make
summary sheet of total sales and related expenses. It is not possibl
to have all regions in the same workbook under different tabs.
therefore need to do a sum whereby the sum function is linked to 4
workbooks. I have all workbooks located in one folder. Is there an
way to make this sum formula easier so that I do not have to go int
each workbook and like the cell to the sum function.
=[test1.xls]Sheet1!$B$3 + [test2.xls]Sheet1!$B$3
[test3.xls]...copying chart to location within same workbook
I have created a chart that I wish to use as a template for many other charts
in the same workbook. I copy it by right-clicking on the tab, ‘name of chart'
sheet, select ‘move or copy’, tick the ‘create a copy’ box and okay. I have
done this hundreds of times in Excel over the last year, but now I get the
A formula or sheet you want to move or copy contains the name 'check', which
already exists on the destination worksheet. Do you want to use this version
of the name?
To use the name as defined in the destination sheet, click Yes.
To rename the range refe...Continuous page numbers thoughout a workbook?
Does anyone know if you can set up a workbook to print with continuous page numbers without going into each sheet and changing the beginning page number?
Edit | Page Setup | Headers and Footers.....create a header or footer.
Click the custom header or footer. It is much like MS Word.
"pagenumbers" <firstname.lastname@example.org> wrote in message
> Does anyone know if you can set up a workbook to print with continuous
page numbers without going into each sheet and changing the be...Links Between Workbooks (Again)
Operating System: Mac OS X 10.6 (Snow Leopard)
I have established links between Workbook "A" and each of 13 other workbooks. <br><br>1. When I change a linking formula in "A", the "Link" dialogue box opens and asks me to re-define the link (i.e. to the appropriate workbook the new formula references). <br><br>2. When I open "A", the "Link" dialogue tells me it cannot find any of the 13 source files, asking me to re-define all the links, even tho...Replacing in whole workbook
I am using excel 2007 when I try to find and replace in the workbook it asks
me for a file name and no matter what I do it keeps asking me and does
The workbook has 6500 items I need to place the same information. I would
hate to have to do each one separately.
Is there a way to do it. I checked on the Internet and it seems that there
is software out there that will do what I want but do not want to have to
pay for it where I am only going to use it once a month.
I tired to select all sheets and got the same results. I want to find "-07-"
and replac...How to evaluate the size of each worksheet in a workbook?
I have a 30+ worksheets in a workbook that is to big....
I would like to know which one are the top memory eater, so I can
concentrate my effort on these one.
Thanks for your help
If you want to know which one try creating the Table of Contents described
which will tell you how many cells are in the used area.
If you want to just try to fix lastcell problems then run the macro
# Why do my scrollbars go to row 500 -- my data ends in cell E50?,
contextures.com, Debra Dalgleish. The basis of deletions is all columns
without content, ..."Cleaning" an Excel workbook
We are going to be entering data in an Excel spreadsheet, and need to
guarantee accuracy. Our plan is to create two identical spreadsheets, have
two people enter data, then check that they are the same - but how??? By
merging them? Or is there a better way to do this check?
Please help - thanks!
If you mean cell by cell comparison (a1 with a1, x99 with x99), you can use a
program written by Myrna Larson and Bill Manville.
You can find a copy on Chip Pearson's site:
look for compare.xla
> We are going to be enteri...GP V8 Password #2
Just check if you are logging in as 'sa'
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-