Question about Computers & Internet

1 Answer

MS Excel 2007 SERIES function

The following function works well for Excel 2003 but not for 2007. What is the problem?

=SERIES("UCL";{1,5};Mech233_X_bar_Chart_Example_1.xls!UCL;2)

UCL is defined name with given value
this function suppose to draw a horizontal line for next 5 points just by one given value. It is convenient instead typing all 5 or 10, 50 etc values just to make horizontal line.

But it seems to me syntax of the function for Excel 2007 has changed. I tried to guess but doesn’t work
… anybody heeeelp…….

Vlad

please e-mail me if you can at: vladoneykov@yahoo.com

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Contributor
  • 51 Answers

First thing: Have yo downloaded *all* the updates available for Office 2007 from Windows Update?

Posted on Mar 20, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Gentlemen: I have downloaded MS 2007 for free from Brothersoft website. After installation, i can't use all the programs, such as excel and word. Every time i attempt to encode, this statement flashes...


Microsoft Products including Office 2007 are licensed software and cannot be used without the product key. You can only download the trial version.
Instead you can use OpenOffice, which is an absolutely FREE and open source office and productivity suite. Refer here to my earlier solution regarding Office Suite. OR. If you wish to use Office 2003, you have to uninstall Office 2007.
To uninstall you can use any uninstaller or uninstall the program using "Add Remove Programs" from the control pannel. As stated by you, if you are having problems uninstalling MS Office 2007, as a work around, manually delete the MS Office 2007 folder from the 'C:\Program Files' and Start Menu. After that you can use the following software to fix the registry entries left by Office 2007 and the remaining files etc.

-You can use Registry fixing software/utility. I have come across a Registry Tool, which is effective to fix common Registry issues. Its Free, small size, easy to use and completely safe. Click here to download CCleaner. Install CCleaner, Click 'ISSUES' and 'SCAN FOR ISSUES' and then click 'FIX SELECTED ISSUES'. Also, Run cleaner from the main interface of CCleaner.

Make a backup of the registry and proceed. You may proceed without registry back, if you like.


Hope it helps! Good Luck!
CreativeTECH

Apr 12, 2011 | Computers & Internet

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet


if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!

Feb 22, 2011 | Computers & Internet

2 Answers

How to Open the Excel file 2003 in Office 2007?


You have to download this compatibility pack and instal it on your machine. Here is the link.

http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

Jan 03, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

Excel stops responding during the saving process


There may be following one or more reasons:-

1. MS office 2007 is currupt
2. System has a virus
3. Windows OS is currupt. (Make sure you are running MS Windows Xp SP2)

Here is the solution:-
1. Scan system with a good legal antivirus
2. Repair OS using utilities win Doctor or from win Xp installation disk (upgrade)
3. Repair MS Office 2007 by going Office Button --> Options --> Resources --> run Microsoft Diagnostics

Zulfikar Ali

Jan 23, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Ms office 2003


Generally  this error occurs because you have deleted your word.exe & excel.exe files to confirm of deletion of these application file you can check by following pathway.  If they are not there means you should restore deleted file from Recycle Bin.

      "C:\Program Files\Microsoft Office\OFFICE11
If the file are not available in Recycle Bin then you should reinstall M.S. Office Application.
Or

You can restore your system to an earlier date when it was working prpoperly.

Jan 13, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Exel 2007 not open in exel 2003


This is because 2007 excel uses a different type of file. You may follow the directions at the link below on how to save files in 2007 excel so that you can open it in 2003


http://office.microsoft.com/en-us/excel/HA100141071033.aspx

Sep 25, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

EXEL 2007


This is because 2007 excel uses a different type of file. You may follow the directions at the link below on how to save files in 2007 excel so that you can open it in 2003


http://office.microsoft.com/en-us/excel/HA100141071033.aspx

If there is anything else please do message me.

Sep 25, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Microsoft office 2007 Compatibility with 2003


MS 2007 is not compatible with MS 2003....because the program hadn't been created yet when 2003 was released. To rectify the problem, you must use the SAVE AS command in your 2007 and in the box where it says file type, select Excel 2003 spreadsheet. It will then save it to a format that your 2003 Excel can recognize.

Thanks and please take a moment to rate as FixYa. Thank you.

Jul 22, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

2,001 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...