Excel

Resolved · Medium Priority · Version 2007

Mon 9 May 2016, 18:11 Delegate Stella said...

Stella has attended:
Presentation Skills course

Excel

HI,

I just wanted to know what meant the following appearing on my screen below:

(Unfortunately cannot copy paste?) however basically this is the message appearing inside a small window :
"An embedded object in this worksheet is created a newer version of Office: etc ...
maybe better get back to me via this way and will be able to explain only tomorrow after 3.00PM.

Yours Faithfully

#Stella Davis

Tue 10 May 2016, 10:09 Trainer Richard said...

RE: Excel

Hi Stella,

I'm not sure which version of Excel you are using, I suspect it might be 2007. Yellow Office logo in the top left corner?

Features that are made on the new versions 2010 or 2013, will not open properly on an older version like 2007. You may not be able to copy and paste either. Copying and pasting also stops working properly if you try opening Excel more than once, for two computer screens.

Has the file been edited by anyone on an upgraded version of Excel? It may be the case that they have used Slicers (Filter buttons) on a Pivot Table, these objects will not show in 2007 and you will get that warning.

Please let me know if that helps

Kind regards

Richard Bailey
Microsoft Certified Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips