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:

5 Answers

How to repair damage excel file


Use Excel Repair Toolbox designed to restore data from corrupted .XLS files. MS Office .XLS file repair software can fix many error.
For more: https://www.xlsrepairtoolbox.com/

Jul 14, 2015 | Microsoft Excel for PC

5 Answers

How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please...


Excel file can be repaired manually if it is less corrupted but Open and Repair program doesn't work if highly damaged due to corruptions. I searched for solutions to repair corrupt Excel file and found one solution which is full of information and provides a guaranteed solution. I am sharing this solution with all the users -Excel Repair Toolbox. Follow the exact steps given in this programm and you will be able to access the data. Download Microsoft Excel Repair tool

May 24, 2015 | Microsoft Excel for PC

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...

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

joecoolvette
joecoolvette

Level 3 Expert

5660 Answers

kakima

Level 3 Expert

98694 Answers

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

Answer questions

Manuals & User Guides

Loading...