| Thread | Last Post | Replies |
|
| worksheet size limit | 30 Jan 2006 23:48 GMT | 2 |
Why are the cells limited to 256 columns and 65,536 rows? Once a format is set and then you realize its limits, its too late and too cumbersome to reorganize the sheets. Are there any future restructuring of these limits to a more even distrubution of rows and columns (30,000 X ...
|
| Cell display | 30 Jan 2006 23:44 GMT | 2 |
I created a workbook that has a summary page with cells that link to cells in other pages of the workbook. These cells are in date format. When there is no entry in the cells of the other pages, the summary page cell shows 1/01/1900. I would like the cell on the summary page ...
|
| Changing source on multiple workbooks | 26 Jan 2006 21:08 GMT | 1 |
We have one main workbook that the supervisor fills out that lists jobs times staff etc. I've just set up links to the daily worksheet workbook that automatically fill in which staff member is doing which jobs eac day.
|
| Workbook with phantom link | 23 Jan 2006 22:08 GMT | 3 |
When I open the workbook excel asks if I want to update links to other workbooks. There are no links, I have searched all the worksheets in an effort to delete them but cannot find any.
|
| Prevent error messagebox when refresing querytable from the web fails | 17 Jan 2006 13:24 GMT | 13 |
I have an excel workbook with a querytable on a sheet The querytable retrieve data from a web site, and I need that data to be checked automatically, and saved when some data is changed. So I create a class to implement QueryTable events, and I have my own
|
| Pop-up windows upon save &/or close | 15 Jan 2006 19:08 GMT | 1 |
Okay....I have a worksheet with 93 tabs, and I'd like a pop-up message box to display when a user attempts to close, print, or save the file, but only if two cells do not contain the same figure. For example, if cell a5=5000 and cell a6=6000, I need a message to display stating that ...
|
| Exporting data in Excel permanently to Access | 12 Jan 2006 03:56 GMT | 1 |
How do I export a range of data which is in a row/column format (i.e., row=record, column=field) in Sheet3 to a file that can then be easily imported to an Access table? Please point me in the right direction on the best way to do this. Thanks
|
| Variable Links to Tabsheets | 06 Jan 2006 00:54 GMT | 3 |
How can I make a link to another sheet be dependable on one cell value (without ifs)? I give you an example: I have a worksheet with three sheets ('Sheet1','Sheet2', and 'Sheet3')
|
| Creating links in work book | 03 Jan 2006 21:18 GMT | 1 |
I would like to Link cells to worksheet so that when entering data in one cell the other cells will have the same data inputted automatically. For instance, I have three worksheets, ws1, ws2, and ws3. In each of the worksheets there are several cells that contain the same data. I ...
|
| Showing URl of link? | 03 Jan 2006 19:42 GMT | 1 |
Hello - Newbie question: I have an Excel file (98) with 1600 names of people Each name is a link to their personal file I need to know how many of the links point to the 'under construction' page
|
| Linking to a pivot table from a formatted invoice | 01 Jan 2006 22:02 GMT | 1 |
Hi people, I have a workbook that is organized as follows: First sheet: "Raw Data" A series of timesheet entries, showing worker, date, number of hours worked,
|