1 Resources for

shared workbooks

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Hyperlinks in Shared Excel Workbooks/Spreadsheets: Hello,I was told that you cannot insert or create a hyperlink in an Excel file that you have saved as a shared workbook. Is this true? And does anyone out there know of an alternate way of inserting the hyperlink?WorkaroundNot sure of alternatives but what you can do...; Tags: hyperlink, shared workbooks, excel, hyperlinks, wattsnew, networking, workbook, shared workbook, Microsoft Excel; Discussion threads 2006-07-27

Additional Resources

Xbriage (msi): Xbriage is a new approach to personal accounting. Functionality is placed in modular tools called workbooks, which can be dragged onto the screen. Several workbooks dragged onto the screen can also be saved as a view, to allow for easy workspace customization. As Xbriage is updated, new workbooks are added,...; Tags: Screen, Approach, Xbriage, Features, Productivity, Operational Accounting, Financial Services, Finance; Software downloads 2008-09-17
Merge Workbooks (zip): Merge Workbooks is an Excel macro that will combine several Excel workbooks into one workbook. The user selects the workbooks to merge and the macro copies all the worksheets in those workbooks into a new workbook.; Tags: Macro, Merge Workbooks, User, Microsoft Excel, Microsoft Office, Office Suites, Software; Software downloads 2006-01-11
Macro to input password for read only workbooks: I have several workbooks that I need to open and recalculate often. All of these workbooks are read only is you don't have the password. I want write a macro to open all of these workbooks and to automatically enter the password as they open instead of me...; Tags: password, gelia_ruple@..., workbook; Discussion threads 2006-10-19
Macro to input password for read only workbooks: I have several workbooks that I need to open and recalculate often. All of these workbooks are read only is you don't have the password. I want write a macro to open all of these workbooks and to automatically enter the password as they open instead of me typing it...; Tags: password, gelia_ruple@..., workbook; Discussion threads 2006-10-19

Excel is closing workbooks automatically: HiI have a user that uses excel quite heavily. Recently his system has developed a quirk where any open Excel workbooks automatically disappear from within excel. He is left with excel open and no workbooks visible. This seems to happen if none of the workbooks have been worked on for...; Tags: Microsoft Office, harvinder.thandi@..., Microsoft Excel; Discussion threads 2007-07-23
Excel Merger (zip): Excel Merger can add up specified cells in different Excel File. When you have lots of Excel files with the same format, such as some sale workbooks from the branches of your company. How to add up each cell in all the workbooks. (For example, How to add up all...; Tags: Merger, Cell, Microsoft Excel, Mergers & Acquisitions, Microsoft Office, Office Suites, Software, Investment, Finance; Software downloads 2007-01-04
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
Excel Workbook Rebuilder (zip): The Workbook Rebuilder has been highly recommended on several Microsoft newsgroups. The rebuilder fixes corrupt workbooks and overcomes many problems including unexplained errors and Excel locking up while saving and opening workbooks.; Tags: Workbook Rebuilder, Microsoft Excel, Microsoft Office, Office Suites, Software; Software downloads 2003-06-21
Creating Multi-Sheet Excel Workbooks the Easy Way With SAS: Transferring SAS data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper discusses using the new XML support in Base SAS 9.1 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). The reader will...; Tags: SAS Institute, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2007-05-14
Navigate between windows in Excel workbooks: When you're working with Microsoft Excel, it's common to have two or more workbooks open at once. Learn a handful of basic ways to efficiently navigate between workbooks. Do you frequently open and work in two or more Microsoft Excel workbooks simultaneously? If so, here are a few...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Open Excel, Alt, workbook, window, Microsoft Office Suite Excel Tips Newsletter, Office Suites, Software; Technical articles 2005-07-19
VBA EXCEL COPY BETWEEN WORKSHEETS: I am trying to consolidate from multiple Excel workbooks loaded individually into a single master spreadsheet via VBA code. The code fragment following works if I reference within the workbook(2), but fails if I copy from workbook(2) and paste across to the master workbook(1).One web reference suggested it was due...; Tags: cell, grhys@..., BegDayCol, EndDayCol; Discussion threads 2007-02-12
Creating And Importing Multi-Sheet Excel Workbooks the Easy Way With SAS: Transferring data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper discusses using XML support in Base SAS 9.1 software to move data between SAS and Microsoft Excel (versions 2002 and later). Through this paper one...; Tags: SAS Institute, Microsoft Excel, Microsoft Office, Office Suites, Software; White papers 2006-02-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
Excel row comparision: Can the following be done with a macro or some other way in Excel 2003 ? I have looked at comparision utilities but most of them add and delete rows which I do not want. Compare rows in two spreadsheets in seperate workbooksHighlight the row in the second...; Tags: Microsoft Excel, rdoucette@..., Sheet1, software; Q&A 2005-03-24
DTS ActiveX Script: I have a DTS ActiveX Script, which I open a excel spreadsheet to Update. It was running fine all the while, until the last 2 days. It ran for over an hours and still not finished. This package usually runs for around 6 to 7 mins the max.I enclose the...; Tags: DTS, DTS ActiveX, DTS ActiveX Script, ExcelObject.Workbooks, kaypaul@..., software; Q&A 2005-01-11
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
Tips and Tricks for Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way With SAS: Transferring SAS data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper discusses using the new XML support in Base SAS-9 software to create multi-sheet Microsoft Excel workbooks (versions 2002 and later). One will learn step-by-step...; Tags: SAS Institute, Microsoft Corp., Microsoft Excel; White papers 2008-03-13
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
Find and Replace for Microsoft Excel (zip): An add-in for Microsoft Excel 2007-2000. It enhances Excel's built-in Find with simultaneous search in values, formulas and comments in all opened or selected worksheets and workbooks. This Excel add-in reduces the number of clicks to one and the search time to a second and adds no new workbooks or...; Tags: Microsoft Corp., Add-in Express, Microsoft Excel, Microsoft Office, Office Suites, Software; Software downloads 2008-07-07

<< Previous
page 1 of 1
Next >>

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now