Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / January 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
worksheet size limit30 Jan 2006 23:48 GMT2
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 display30 Jan 2006 23:44 GMT2
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 workbooks26 Jan 2006 21:08 GMT1
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 link23 Jan 2006 22:08 GMT3
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 fails17 Jan 2006 13:24 GMT13
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 close15 Jan 2006 19:08 GMT1
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 Access12 Jan 2006 03:56 GMT1
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 Tabsheets06 Jan 2006 00:54 GMT3
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 book03 Jan 2006 21:18 GMT1
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 GMT1
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 invoice01 Jan 2006 22:02 GMT1
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,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.