| Thread | Last Post | Replies |
|
| Sharing excel worksheets | 15 Oct 2004 18:47 GMT | 2 |
Is there any way possible that I can put three separate Excel spreadsheets on three separate computers and if one makes a change on any one of the spreadsheets and saves it, that it replicates on the other two. The same changes
|
| How to copy protection details | 15 Oct 2004 18:39 GMT | 1 |
I have a protected sheet(Sheet1) with some cells unlocked. I want t copy the contents of Sheet1 to Sheet2 with the protection retained. If I do a Copy&Paste the protection details are lost. Is there a way to copy protection details also
|
| Update records from one spreadsheet to another | 15 Oct 2004 18:26 GMT | 1 |
I am trying to update a old spreadsheet with a new spreadsheet. Th original spreadsheet is the property records for the county that I liv in. The new sheet is an update of properties sold. Each sheet uses unique "PIN" (Property Indentity Number) for every property record i
|
| need help on updating figures | 15 Oct 2004 17:56 GMT | 1 |
i've attached my file. i hope it makes it easier to understand and hope you can help me +-------------------------------------------------------------------
|Filename: project2.zip |
| Slow Spreadsheet | 15 Oct 2004 16:23 GMT | 1 |
We are working with a spreadsheet with +60,000 lines and is very slow when sorting it. It is even slow to open initially. What settings will optimize the use of this sheet?
|
| Opening .XLS files | 15 Oct 2004 16:21 GMT | 1 |
I am having a problem opening files from the desktop or file explorer. Exell opens but it the file does not. If I open exell first then open files through exell it works.I have tried repairing office and that did not work. Any ideas?
|
| Using the result of date math in regular calculations | 15 Oct 2004 16:20 GMT | 1 |
I doing date math on a Hourly Pay worksheet (for a class). 5:30 - 1:30 = 4:00 - I want to take the result of the subtraction (4:00) and multiply it times a Hourly Rate cell except the format of the number of hours is in a custom/date format. What's the easiest way to convert this ...
|
| getting external data | 15 Oct 2004 13:53 GMT | 3 |
Does anyone know how to dowload data from web sites? I have a template file from Microsoft that downloads stock data from MSMoney and places it into a grid. I want to do likewise, but with different data from that site or from Yahoo, But I can't seem to get the data to go into the ...
|
| sorting in excel | 15 Oct 2004 13:31 GMT | 2 |
how do i sort addresses in excel. i have saved the addresses in thre rows. for example *_address_______|______details_______________ * ----------------|----------------------
|
| Cell comments | 15 Oct 2004 13:15 GMT | 1 |
Is there any way to stop cell comments resizing when inserting new rows above or below the cell with the comment, as at the moment if I insert a row above a row which has a cell with a comment, the comment will resize in height and it's very very very annoying.
|
| XML query in Excel | 15 Oct 2004 09:58 GMT | 1 |
win xp, excel 2003. i would like to ask if i can do any relational query on an xml data source inside excel. say, i have an xml document: employer.xml
|
| Import from another spreadsheet | 15 Oct 2004 06:04 GMT | 1 |
Not a typo. I have over 100000 rows of data in one spreadsheet. Sorry, I don't know who Chip is. Thanks
|
| Page format for Calculation Sheet | 15 Oct 2004 06:03 GMT | 1 |
I've spent some time trying to optimize a standard page with borders and a title area, to behave like a handwritten calculation sheet for engineering. Problem: If the user changes a column or row width or height the borders move, too. I concluded that all borders, col and row ...
|
| With highest value on given range | 15 Oct 2004 05:12 GMT | 2 |
I need help with my data as seen below: A B C D E F G H (Result) 1 UserA 750 750 1500 1500 1500 750
|
| Can Solver Tackle This? | 15 Oct 2004 04:08 GMT | 3 |
I'm not sure if this is the correct group to post to but I had a solver question. I have been looking at the Solver tool briefly, and have also viewed some Sample spreadsheets that showed its capabilities. I was wondering if it could handle something like the
|