ExcelBuffoon
New Member
- Joined
- Oct 31, 2005
- Messages
- 19
What a great site.
My first question is, well actually two...
I have a spreadsheet (read only) which I have created for use to show holidays taken etc. After scouring the Internet (and tried a very buggy Holiday Planner Network Edition by Web-Wiz), I decided to create my own, which I'm very proud of. Essentially, I have a master spreadsheet, where I input all of the data using coloured blocks (cells), and then calculate how many of these are in a given month by using COUNTIF, example: =COUNTIF(B6:AE6,D$25)+(COUNTIF(B6:AE6,D$27)/2)
I then have another read-only spreadsheet that gathers and displays all this info to show totals and what's left etc. There is a section which gives totals of days taken in a given month for a person (in a single cell). Most of these will show 0, but where a month may show a number such as 2 or 10 etc, I would like it to display in bold. Can you tell me what I need to add to the cell? At the moment it simply shows =(path to spreadsheet and cell)
Also, when I open the readonly copy, It asks if you want to update data due to links to other worksheets. Is there a way to bypass this so it always updates regardless? There would never be a point in not wanting to view the latest information. Also (sorry, three questions!)
Is there a way to not be prompted to save? Most people will not be able to save as it is in a read only area of the network. I would rather it just loaded, displayed the live current data imported from the other master sheet and then closed again without any nags.
Thanks a lot.

My first question is, well actually two...
I have a spreadsheet (read only) which I have created for use to show holidays taken etc. After scouring the Internet (and tried a very buggy Holiday Planner Network Edition by Web-Wiz), I decided to create my own, which I'm very proud of. Essentially, I have a master spreadsheet, where I input all of the data using coloured blocks (cells), and then calculate how many of these are in a given month by using COUNTIF, example: =COUNTIF(B6:AE6,D$25)+(COUNTIF(B6:AE6,D$27)/2)
I then have another read-only spreadsheet that gathers and displays all this info to show totals and what's left etc. There is a section which gives totals of days taken in a given month for a person (in a single cell). Most of these will show 0, but where a month may show a number such as 2 or 10 etc, I would like it to display in bold. Can you tell me what I need to add to the cell? At the moment it simply shows =(path to spreadsheet and cell)
Also, when I open the readonly copy, It asks if you want to update data due to links to other worksheets. Is there a way to bypass this so it always updates regardless? There would never be a point in not wanting to view the latest information. Also (sorry, three questions!)

Thanks a lot.