Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Daycare Manager (exe)
- The Daycare Manager is a Microsoft Excel Workbook that uses customized forms, sheets, and VBA code to help you manage your daycare operation. The Daycare Manger lets you manage children, guardian, and employee demographics, checking, check writing, accounts payable/receivable GL (which is linked to the check writing, GL, and checkbook),...
- Tags: Daycare Manager, Workbook, Microsoft Excel, Taxes, Microsoft Office, Free Trade, Office Suites, Software, Financial Planning, Finance
- Software downloads 2008-02-15
- Linking multiple Excell workbooks
- I have one master workbook and 10 dependent workbooks. What I would like to do is have the dependent workbook automatically update with specific information from the master. I am trying to generate sales reports for individual salesmen. The master is set up with simple columns date/customer/product/price/sales#....
- Tags: Sales strategy, james.odonnell@..., workbook
- Discussion threads 2007-11-16
- Dynamic Web Query freezes Excel
- I have asked this same question elsewhere on the forum, but thggought I would start a new thread.Hello, I have been searching for a solution to my Dynamic Web Query for nearly 12 months, this thread is as best as it can get to describe a similar problem I can...
- Tags: Microsoft Office, PB-1, Microsoft Excel, Sheet5, workbook
- Discussion threads 2007-11-18
- Excel: Shared a workbook and now spreadsheet will not calculate
- I have a sorce spreadsheet for which another sheet is linked to pull data. I shared the workbook which may or may not be part of the problem. When I make formula changes in the workbook, the formulas are copying and show in the cell, but the calculation...
- Tags: PRODUCTIVITY, Microsoft Excel, cmikesh@..., workbook, cell, spreadsheet
- Discussion threads 2007-10-30
- Update links in excel
- from Microsoft :"Don't ask whether to update links when I open any workbook, and update links automaticallyThis option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected. This option also affects links to other workbooks." Is there a way to...
- Tags: highlander718, workbook
- Discussion threads 2007-08-28
- Autonumber the workbooks in folder
- i have this macro added in excel, this macro prints the excel files one by one in a specified folder, thsi works finethe problem is that i need to add the increment number in all the workbooks( suppose i have 200 workbooks, i need to add 1, 2 , 3...
- Tags: get2santosh@..., sFile, UBound, String Dim, workbook
- Discussion threads 2007-07-28
- Unshare a shared workbook
- I've created a master file for multi users where I've done a lot of conditional formatting, drop down menues and locked sensible cells containing formulas. The moment I thought I was done test driving it, I said to myself I should make it shared. Now, after further testing I realized...
- Tags: xplan_nation@..., workbook, cell, Share Workbook
- Discussion threads 2007-07-24
- How to Recover from Excel Workbook Bloat
- The average Excel workbook is about 14 kb. Occasionally, you end up with a file that's much larger than it needs to be. Bloat can turn into a serious problem for busy workbooks. As the file grows, performance slows down. In fact, occasionally a workbook grows so large that users...
- Tags: Excel
- Blog posts 2007-05-24
- Shared Workbook giving "read-only" message when saved
- My department is using a shared workbook for tracking department data, and some of our users in the department work remotely through a VPN. One of these remote users is having a problem saving to the shared file. The workbook opens, and he can write to it, but...
- Tags: VPNs, ncurrent@..., shared file, remote user
- Discussion threads 2007-04-18
- Paste Values From One Workbook To Another Using vba To Bypass The Clipboard
- Hello all, I am trying to copy one data range in one workbook, that has been assigned a name, to another data range in another workbook using a macro. Now, I have managed to do this without a problem but I keep getting messages popping up asking if I want...
- Tags: matthew.dalton@..., workbook
- Discussion threads 2007-04-27
- Using an Excel Ref as a filename link to other data to display
- I have a database set up in Excel were I have many excel workbook files One for each serial numbered itemwhere I keep track of important information about that item. I also have an overview sheet that lists each serial number in column A followed by important information pulled...
- Tags: Jimboni@..., workbook, cell, Microsoft Excel
- Discussion threads 2007-04-09
- Two Users Acessign Same FIle over LAN.....Help
- I have two sometimes more, users accessing an Excel spreadsheet on a network drive. The dialog box that used to come up that says someone else is working on the file no longer pops up. It used to give you the choice of Notifying the user, Opening a Read only...
- Tags: jshoemaker21@..., Microsoft Office, Microsoft Excel, workbook, dialog box, LAN
- Discussion threads 2007-03-28
- excel vba macros
- hello, I am wondering what the best/easiest way to do this is. I have 2 worksheets from a workbook called Annual Budget that I want to copy essentially. I grouped graphs from multiple spreadsheets into one tab, and want these other 2 worksheets from Annual Budget to...
- Tags: Microsoft Excel, mlarsen1982@..., workbook
- Discussion threads 2007-03-19
- How does one pull Excel data from 200 workbooks into 1 report?
- So how would one go about pulling data from 200 Excel workbooks into one report? Either another Excel book, or a text file or something other than 200 Excel wookbooks.The workbook is a "form" that was created for 200 students, so the cells I need to pull from are...
- Tags: jolson@..., Microsoft Excel
- Discussion threads 2007-01-23
- Microsoft Excel 2003
- I have a workbook with several worksheets, within the workbook I have a master worksheet that has a compilation of all the other worksheets. What I need to happen is I want to add the total columns in the other worksheet and display the totals on the master worksheet; the...
- Tags: worksheet, tru.notoma@..., IBCT NG, windows, windows xp, security, software, career, it management, hardware, networking, excel, e-mail, microsoft office 2003, workbook, Microsoft Corp., Microsoft Excel, cell
- Discussion threads 2007-02-22
- Keep track of worksheet changes with Excel's shared worksheet feature
- With Excel's shared worksheet feature, you can view other users' insertions and deletions and decide whether to keep or delete them. Mary Ann Richardson explains how to use this feature. At the end of a quarter, you might distribute a summary sales worksheet to all department heads. To...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, workbook, Click Accept, Track Changes, Microsoft Office Suite Excel Tips Newsletter, TechRepublic Inc., Office Suites, Software
- Technical articles 2006-09-12
- Damaged Excel File
- I have an extensive excel workbook done in Office 2002. Many worksheet are liked with formulas and formatting. My standard use of this workbook is like this: I open the "blank" version of my workbook, input varialbe information, and "Save As". When I try to access the saved document...
- Tags: workbook, downtownjms@..., damaged excel file 1, software, worksheet, Microsoft Excel
- Discussion threads 2007-02-13
- Compare workbook data side-by-side with Excel 2003
- Working in Excel 2003? You can still compare two workbooks side-by-side. In this tip, Mary Ann Richardson explains how to compare the two with ease. Before Excel 2003, you could use the Window | Arrange menu to perform a side-by-side comparison of two workbooks on the screen. For...
- Tags: Microsoft Excel 2003, Microsoft Excel, Microsoft Office, Mary Ann Richardson, workbook, Microsoft Office Suite Excel Tips Newsletter, Window, Office Suites, Software
- Technical articles 2006-08-22
- Excel File data transfer from another Excel File
- How to transfer excel cell data from one excel file to another excel file.Link to another Excel workbookOpen both workbooks and make sure the destination workbook which will contain the link to the other workbook, is saved. Select the cell you want to link from. If you want...
- Tags: workbook, Microsoft Excel, qfaisala@..., software, programming, visual basic, cell
- Discussion threads 2007-02-05
- Save time formatting in Excel with custom styles
- Cellls are building blocks of your Excel document. In this tip, Mary Ann Richardson teaches you how to reformat cells all at once using a set style. Are you tired of reformatting Excel cells over and over again with the same format? Then create a style that will...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, cell, workbook, Go-to Format, Microsoft Office Suite Excel Tips Newsletter, Style, Office Suites, Software
- Technical articles 2006-07-18
