Showing related tags and posts accross the entire site.
-
All- Please help. I am entering a concatenate formula that is showing me the correct result in the function input box, but the result is not populating in the cell. I have used Excel for years and I have checked the autocalculation option; it is on autocalculate. When you copy the formula down to other...
-
Normal 0 21 false false false MicrosoftInternetExplorer4 <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font...
-
A macro-enabled 2007/10 workbook (xlsm) with the matches from the 2010 World Cup in South Africa. Full instructions on the opening sheet. Add participants and predict scores which will automatically update the participants and the actual teams tables Have fun and Come on England!
-
I have created an elementary line chart in an elementary single sheet workbook. When I print at 100% scaling under page setup all is fine. If I fit to the page, requirng an scaling at 75% to fit, the chart no longer prints or appears in print preview in the correct place. It seems as if the scaling on...
-
One of our users created a file using 2007, and saved as .xls. When others try opening the file, in 2007 the message is: Access Denied. Contact your administrator In 2003, the message is: Excel cannott access 'filename.xls'. The document may be read-only or encrypted. I think he was messing with...
-
Dear friends, I have a file for which i had put some password in the past and now im not able to use any of the normal password which i use normally. Can anyone help me on how do i reset the password now. Also is there any free softwares available for doing this job. THanks in advance Regards MAthew
-
L.S. I would like the code for a button like the Paste button in the Clipboard Group on the Home tab. A button which you can click but also with extra options in a drop down. Can someone please hint me in the good direction thnx
-
I have about 20 macros on an Excel 2007 spreadsheet. I have added buttons into the QAT. Unlike Office 97 - the buttons aren't labelled and the design of each button is limited to the choice of 180 available. You would think this was enough, but it isn't . What happened to the ability to design...
-
Hi all, firstly I am wanting to plot a non linear XY data set (essentially 2 sets of nearly linear data with different slopes). then I would like to start working from the end pair of XY point with a linear trendline adding a pair to the trendlne fit at a time, examining the r value (correlation coefficient...
-
Was just upgraded to Excel2007 from Excel 2003. When I try to print any file created in Excel 2003 that has a pic/text box/ chart or any other object in the workbook it prints out of alignment(pics on text, text box/pics in different locations. It looks fine on the screen but when you print or print...