My First Question.

ExcelBuffoon

New Member
Joined
Oct 31, 2005
Messages
19
What a great site. :-D

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!) :o 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.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Go to Edit. Links, click startup prompt button and you'll see the option you want to get rid of the prompt window.
 
Upvote 0
Done that. It still prompts me! I've selected do not prompt and update (bottom selection) then update values, then saved. It still prompts when I open!
 
Upvote 0

Forum statistics

Threads
1,226,588
Messages
6,191,888
Members
453,684
Latest member
Gretchenhines

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top