Excel - office 2007 excel compatability

Why would excel in office 2007 have trouble opening a 1997-2003 .xls document?

  ShaneDevenshir replied...

Hi,

Have you installed the compatibility pack:

http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en

This is a free download from Microsoft.
--
Thanks,
Shane Devenshire

  BarbReinhard replied...

I've noticed that certain .xls files opened in 2003 don't show errors, but
when the same files are opened in 2007, they do have errors (only found by
2007).   What kind of issues are you having?

Barb Reinhardt

by checking and unchecking filter options? - - If this helps, please click the Yes button Cheers, Shane Devenshire Hi Shane, thanks for your answer. It is a manually grouping. Here is a picture: http: / / michaeltarnowski.de / temp / Clipboard02.gif Michael Hi Shane, thanks for your answer. It is a manually grouping. Here is a picture: http: / / michaeltarnowski goes wrong - nobody has a clue. - - If this helps, please click the Yes button Cheers, Shane Devenshire On Feb 15, 1:19 am, Shane Devenshire Shane, the grouping happens in the field "weeks open". As you see, "weeks open" is

Any advice or assistance would be appreciated greatly. Excel Worksheet Discussions GETPIVOTDATA (1) ShaneDevenshire (1) Devenshire (1) Christi (1) Claire (1) Requestor (1) Senario (1) Shane (1) Hi, You've showed us what you have, but not how its laid out order date name acct type 1 11 / 11 / 2008 shane 21 a b c d 2 11 / 11 / 2008 bill 31 b c d 3 11 / 11 / 2008 shane 21 c or acct order date name type 21 1 11 / 11 / 2008 shane a 21 1 11 / 11 / 2008 shane b 21 1 11 / 11 / 2008 shane c 21 1 11 / 11 / 2008 shane d 21 3 1 / 1 / 2008 shane c 21 3 1 / 1 / 2008 mary a

you get 5 from COLUMN(D)? - - If this helps, please click the Yes button Cheers, Shane Devenshire For A1 = 52 this gives BZ instead of AZ For A1 = 78 this gives CZ FIND("$", ADDRESS(1, A1, 2))-1) - - If this helps, please click the Yes button Cheers, Shane Devenshire Hi, and here is an even shorter method: = LEFT(ADDRESS(1, A1, 2), LEN(ADDRESS FIND("$", ADDRESS(1, A1, 2))-1) - - If this helps, please click the Yes button Cheers, Shane Devenshire Hi, And to take the last simplification and go further: from = LEFT(ADDRESS(1, A1 1, A1, 2), 1+(A1> 26)) - - If this helps, please click the Yes button Cheers, Shane Devenshire Nice going Shane. . . I would definitely call these formulas the "elegant" ones the OP was

the new spreadsheet without a problem. If this helps, please click the Yes button. Cheers, Shane Devenshire Cheers, Shane Devenshire The problem of importing from a website is solved. There I can disable the function the new spreadsheet without a problem. If this helps, please click the Yes button. Cheers, Shane Devenshire Cheers, Shane Devenshire Re: converting to dates. . . The problem of importing from a website is solved. There I

an IF statement in there? Excel Discussions SUMPRODUCT (1) SUBTOTAL (1) SUM (1) MAX (1) Devenshire (1) Shane (1) Tricker (1) Spans (1) Hi, You might consider an SUMPRODUCT function such as: = SUMPRODUCT A1:A5, A7:A11)-A13:A17)) If this helps, please click the Yes button Cheers, Shane Devenshire = SUMPRODUCT(- -(IF(A1:A5> A7:A11, A1:A5, A7:A11)-A13:A17> 0), - -(A1:A5 A7:A11, A1:A5, A7:A11)-A13:A17)) , A1: = ADA5, A7:A11)-A13:A17)) Hi Shane I tried your suggestion, but it just gives a #VALUE error (even if i press this is the result you want but with dummy data I get a result. Cheers, Shane Devenshire On Nov 25, 11:51 = A0am, Shane Devenshire 11, A = AD1:A5, A7:A11)-A13:A17) mmy Shane That works, but i