| Thread | Last Post | Replies |
|
| Changing External Data Location | 31 Mar 2008 07:50 GMT | 1 |
I have a fairly complex workbook that I used on a regular basis. The first thing it does is get a data extraction from an ACCESS database that is located on a different computer over the LAN using MSQuery. Recently, my IT department swapped out the computer that stored the
|
| Linked cell returns a 0 where there is no text (sometimes) | 28 Mar 2008 13:43 GMT | 3 |
The contents of cell P10 on sheet("Issues") in T:\Storage\1.Reporting\DB\RAID logs\RAID log.xls is empty. The contenst of cell P8 on sheet("Issues") in T:\Storage\1.Reporting\DB\RAID log.xls reads "='T:\Storage\1.Reporting\DB\RAID log\[RAID Log.xls]Issues'!
|
| Need to transfer sheet + pictures to multiple computers | 21 Mar 2008 19:15 GMT | 3 |
I am looking for a way to easily transfer worksheet + pictures to several computers. I have the pics hyperlinked to "My Pictures" on my computer. How can I save them so that I will be able to load the worksheet on multiple computers without breaking the link? I have not
|
| Link - Value Not Available | 20 Mar 2008 21:59 GMT | 5 |
I have a workbook that links information from about 6 other workbooks. The other workbooks are in a read-only area from another department. The linked information is simple text only cells. Everything has worked fine for years, except on rare occassions. Once in
|
| Open file | 18 Mar 2008 21:19 GMT | 5 |
I export SPSS file to Excel. When I open this file in Excel I have warning: FILE ERROR: DATA MAY HAVE BEEN LOST. What does this mean ?
|
| How to make the Embedded Excel file link to the table of Access | 18 Mar 2008 08:28 GMT | 1 |
i embedded an Excel file into a Form of Access database, and then added a PivotTable in that Excel file, so how to make the PivotTable directly link to the table of that Access database?
|
| Hyperlink help | 16 Mar 2008 16:09 GMT | 6 |
I have a small website that uses files from a web development package Word docs and Excel spreadsheets saved in htm files. I link from on to the other but my spreadsheets now have multiple worksheets in the and the links form Word only go to the first tab/worksheet.
|
| balances in a single worksheet | 12 Mar 2008 08:43 GMT | 1 |
I have 26 customer account excel files on a network drive (shared) and I would like to create an excel file on my computer that shows all of my customer balances in a single worksheet. I tried doing this by using links.
|
| Keep hyperlinks uon archive | 12 Mar 2008 08:32 GMT | 1 |
I use a spreadsheet to track documents on projects and link the number to each actual documet for quick retrieval. The project I'm setting up will be of many years duration so the early portions will be archived. I want to maintain the links when the sheet gets moved to archive. ...
|
| Create a search feature in a worksheet | 04 Mar 2008 01:08 GMT | 1 |
Hey all This is my first post on this lovely forum i am hoping i cold get some help because i need it urgently, i have searched around incase third thread has already been posted but it has not so please help.
|
| Help? | 01 Mar 2008 13:31 GMT | 2 |
I need some help on a checkbook register workbook that I am making. I have a column that is labeled as CATEGORIES which is a drop down list which contains.... "auto,household,medical,misc.. I want this register to be linked to a summary sheet which should show how much I spend in ...
|