Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

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


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

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.