| Thread | Last Post | Replies |
|
| link a local spreadsheet to a network shared spreadsheet | 21 Mar 2008 11:37 GMT | 1 |
I have a local spreadsheet, Book1. Saved a copy of spreadsheet, Book2 on a network shared directory. For any cells that are updated on local spreadsheet, Book1, I need to have the network spreadsheet, Book2 update with same changes. If I put formula on Book2 cell to = Book1 cell, ...
|
| Anoth vbscript question ... sorry ! | 20 Mar 2008 22:22 GMT | 1 |
I have used VBScript in a spreadsheet to perform various functions btu im a little confused as tohow to do the following: On one of my userforms, i have two checkboxes eith or both of which can be selected.
|
| how to keep the tool bar open | 19 Mar 2008 20:04 GMT | 1 |
How do I keep the tool bar open and visible all the time while i am using Excel? It keeps disappearing after I use it once.
|
| Help ! How do I do this in VB Script | 17 Mar 2008 13:16 GMT | 3 |
I have a spreadsheet with a Summany sheet and 235 deatil sheets. I have various scripts that create the tabs, which are basically a summary of monthly values for each of our suppliers. I want to use vbscript to add totals to each supplier sheet but im having
|
| Size of letters in comments | 14 Mar 2008 09:50 GMT | 1 |
The default is 8 which is too small. Everytime I write a comment I've to change manually the size if the letter. It is not possible to change the default (to 10, for exemple)? Thank you
|
| automatically insert new rows in a list | 14 Mar 2008 09:37 GMT | 1 |
Good Afternoon, I use Excel 2003 in Win XP. I am creating a spreadsheet that includes multiple "CTRL + L" lists for the purposes of scheduling concerts.
|
| modify template | 12 Mar 2008 11:16 GMT | 1 |
i know how to modify the template location on a single computer, but i wanted do it on several computers have someone a vbs script to do it ? thanks
|
| Can Excel automatically open a defaul file on startup? | 11 Mar 2008 08:09 GMT | 1 |
I would like to have Excel (version 2007) automatically open the same file as a default upon startup. Is this possible? We have three people working on the same file, and somehow multiple copies keep showing up that aren't necessarily the most up-to-date saved. It makes a mess ...
|
| Location of default workbook in Excel 2007 | 09 Mar 2008 17:52 GMT | 1 |
Where is the default workbook found (path/filename) in Excel 2007? In E-2007, I tried opening my old one, Book.xls (from E-2000); it was not the same thing I get when I start a new workbook in 2007.
|
| inserting rows where a formula is inuse for that column | 07 Mar 2008 22:38 GMT | 2 |
i have a spreadsheet in excel 2003 that i use to figure trucking miles and the rate for those miles. it is done in alphabetical order. when i need to add a row, how do iget the formula to apply to that row like the others.
|
| change the default working folder | 07 Mar 2008 22:31 GMT | 1 |
How do I change the default working folder in Excel? I've followed the instructions on the help, but it changes back every time I close the program.
|
| XLS in CSV with " and ; | 07 Mar 2008 04:10 GMT | 1 |
we have a XLS (Excel 2007) file and want to save it as *.csv in the format like "datarecord";"datarecord2";"..... but Excel only uses ; and no " signs between the data. Does anybody know how to get this solved? Thank you in advance
|
| Copy down repetitive rows | 06 Mar 2008 14:48 GMT | 2 |
I have a string of data that I need to populate in repetition down several thousand lines for my filter strings to work properly. Right now, I am copying and pasting. Is there a function I can use to make this task easier? See below, I need to repeat the rows to associate all ...
|
| Is there an auto save in Office 2007 Excel | 03 Mar 2008 22:38 GMT | 2 |
Is there a setting somewhere for a spreadsheet to automatically save every 10 minutes, as there was an option in previous versions of Excel?
|
| match data by day | 03 Mar 2008 07:26 GMT | 1 |
I have some excel sheets and have a question regarding grouping the data by day. I want to compare sales figures for each day of current month compared to last financial year corresponding month. The catch is that I dont want to compare each date (ie compare 1st December of ...
|