Functions
in [Excel]
|
"manual page breaks error" I am getting an error message when I try to open my excell file saying "this action exceeds the number of page breaks you can manually add to a worksheet. A worksheet can contain up to 1026 horizontal page breaks. This is a file that was developed in 2004 and has been set to calculate personnel salaries and th... 20 Jun 2007 17:38
formula: count if not blank I have two columns, a date in the left, and in the right a formula to calculate the date plus 14 days. For some of the cells in the left column, there won't be a date right away. I want to have the formula to calcualte the date in all the cells in the right column so when i do enter a date in the left, it jus... 16 Nov 2006 16:06
Problem to close a group of columns I have a speed sheet in which I have grouped the columns into different groups. Some of these groups II can open and close without any problems BUT some of the groups I can not any longer close, when I try I get an error pop up with this text: “Objekt kan inte flyttas utanför blad” in English ruff “Object can not... 13 Nov 2006 12:55
Cannot start the source application for this object An Adobe document is embedded into an excel program (as a package) and whenever we try to open the pdf we get the error "Cannot start the source application for this object". I have upgraded the Adobe Reader to version 7.0.8. If you right click on it and select copy then go to the desktop and select paste it w... 26 Oct 2006 12:36
Hyperlinks in Excel I've just spent the best part of a day entering hyperlinks to files in a shared drive - eg '\\servername\drive\filename.pdf' After closing the worksheet and opening it up again, I now find that Excel has amended all the links to '../../drive/filename.pdf' so that when I click the link it thinks I'm looking for a... 19 Oct 2006 16:31
Reverse output of the Linest function Hi I want to use the Linest function for multiple regression however it has an annoying feature where by the coeffecients are listed in descending order along the row. Is there a way to flip a row (or column for that matter) so that the constant is shown first followed by the remain terms in ascending order... 2 Oct 2006 03:13
MGRS to Lat/Long Does anyone know a formula to convert military grid reference system to decimal degrees? -- balderdash ------------------------------------------------------------------------ balderdash's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34153 View this thread: http://www.excelforum.com/showthrea... 8 May 2006 05:37
intercept graph vs. function Hi: I have a small data set, and I'm trying to do make some forecasting functions work, so I use the INTERCEPT() and SLOPE() function in order to get the line's major elements. BUT! When I double check the INTERCEPT() and SLOPE() results with the Trendline that Excel has done using the data set, I get completely... 1 Feb 2006 19:17
Web scraping Morning all, Currently have Excel2000. Would like to scrape webpage into Excel (ALT_D_D_W) from the URL- http://newsite.tab.co.nz/racing/ It comes back with error message "Returned no data try editing query" (ALT_D_D_E) Tried editing with no joy, can anyone out there overcome this challenge? Regards Mick Bar... 1 Feb 2006 05:32 |