Do a search on google eg linked below
https://www.google.com.hk/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=Repaired%20Records%3A%20Drawing%20from%20%2Fxl%2Fdrawings%2Fdrawing2.xml%20part%20(Drawing%20shape)
You will see millions of people suffering this problem where they have a slightly more complicated .xlsm file that when saved in Excel 2010, it gets corrupted and pictures/charts and button controls gets deleted. Usually the file had started its history in Excel 03 then 07.
MS seems to have no proper fix. except tell users to recreate the file into a 2010 Workbook. Well for some people that just requires too much time although one should consider this as a mini project to fix the problem.
However, here is a short term work around.
Assuming you only have Excel 2010
Open the xlsm. Make you changes like adding a formula to a cell.
Do a Save As for the file but save it in 2003-07 xls format. It will prompt for issues. Click OK.
Close Excel
Open the new .xls file in Excel 2010.
Do a Save As again and save it as a .xlsm file. Close the file and Excel.
Open the new .xlsm again in Excel 2010.
And voila it seemed to have saved without getting the file corrupted and then removing its charts/pictures and button controls.
There is a second method that can also side step the problem. I think it shows up this is a bad bug from MS which they ought to try to address.
Open the xlsm. Make you changes like adding a formula to a cell.
Do a Save As for the file. Change the name of it. Keep it as xlsm Click OK.
Close Excel
Rename the file back to its old file name.
Open the new .xlsm again in Excel 2010.
And voila.
Apparently, this bug is NOT just affecting xslm file, it affects xlsx files that have formulae and links, references with other work books. It affects files who had a history of being started in 2003 or before xls format.
Show By Category
.NET Service
(1)
1909
(1)
ACTV
(1)
adidas
(47)
adizero
(1)
Admiral
(9)
Airness
(3)
Albania
(3)
Algeria
(3)
America Mineiro
(1)
Angola
(1)
Anta
(2)
Argentina
(2)
Armenia
(1)
Atletico Goianiense
(1)
Atletico Paranaense
(1)
Austria
(2)
Authentic fit
(1)
Auto Generate from Access
(1)
Avai FC
(1)
avoid
(2)
Bahia
(1)
Beijing Guoan
(1)
Belgium
(4)
Benin
(1)
Birmingham City
(1)
Bolivia
(1)
Boot Configuration Data missing
(1)
Bosnia
(1)
Botafogo
(2)
Botafogo SP
(1)
Botswana
(2)
Brazil
(4)
Brazilian brand
(15)
Bulgaria
(2)
Burkina Faso
(2)
Burrda
(3)
Bypass traverse checking
(1)
Cambodia
(1)
Cameroon
(4)
Ceara
(1)
CEWP
(2)
Chapecoense
(2)
Chile
(3)
China
(9)
Chinese Brand
(4)
Chongqing Lifan Dangdai
(1)
Club Deportivo Universidad Catolica
(1)
Club Universitario de Deportes
(1)
Clube de Remo
(1)
Colombia
(6)
Colombian Brand
(1)
Congo DR
(1)
Congo Rep
(1)
Copa America
(3)
Corinthians
(1)
Coritiba
(1)
Costa Rica
(2)
Cote d'Ivoire
(3)
Coventry City
(1)
Croatia
(2)
Crop IFRAME
(1)
Cruzeiro
(2)
Crystal Palace
(4)
css
(3)
Cuba
(1)
Cyprus
(1)
Czech Republic
(2)
Deleting large libraries
(2)
Denmark
(2)
design fault
(2)
Diadora
(1)
Dragao Premium
(1)
eagles
(1)
Ecuador
(3)
Ecuadorian Brand
(3)
Egypt
(1)
El Salvador
(1)
electrical
(2)
electrical problems
(2)
electrocuted
(2)
England
(3)
Errea
(3)
Espanyol
(1)
Ethiopia
(1)
Euro 16
(10)
Excel 2010
(3)
External Content Type
(1)
FBT
(3)
FC Porto
(1)
Fenerbahce
(1)
Figueirense
(1)
Finland
(1)
Fiorentina
(1)
Flamengo
(1)
Flickering
(1)
Fluminense
(1)
football
(233)
Fortuna Dusseldorf
(1)
France
(2)
futfanatics.net
(1)
Gabon
(1)
Germany
(1)
Ghana
(2)
Gogoalshop
(2)
Goias
(1)
Granada CF
(1)
Grand Sport
(2)
Greece
(2)
Green
(1)
Guangzhou Evergrande
(1)
Guinea
(1)
Guinea Bissau
(1)
Haiti
(1)
Heilongjiang Lava Spring
(1)
Honduras
(1)
Hong Kong
(1)
Hummel
(1)
Hungary
(1)
Iceland
(3)
Icone Sports
(2)
IE Developer Tools
(1)
India
(1)
Indian Brand
(1)
Internal Field Names
(1)
Italy
(2)
Jako
(1)
Jamaica
(2)
Japan
(1)
Javascript
(6)
Jersey
(126)
Jiangsu Suning FC
(1)
Joma
(5)
Kanxa
(1)
Kappa
(3)
Kelme
(4)
Kenya
(1)
kitchen extractor fan
(3)
Korea
(1)
Laos
(1)
Le Coq Sportif
(1)
leak
(2)
Legea
(1)
Levante
(1)
Li Ning
(3)
Local Security Policy
(1)
Login Problem
(1)
Lotto
(4)
Lupo
(2)
Macron
(9)
Mafro
(3)
Mali
(3)
Man Utd
(1)
Marathon Sports
(6)
Marseilles
(1)
masterpage
(1)
Meizhou Hakka
(1)
Mexico
(5)
Modena Volley
(1)
Montenegro
(1)
Morocco
(3)
Myanmar
(1)
N98
(1)
Naija
(1)
Nakal
(1)
Namibia
(1)
Napoli
(1)
Netherlands
(1)
New Balance
(2)
Newcastle United
(2)
Niger
(1)
Nigeria
(4)
Nike
(32)
Nike Brasil
(1)
Nike Brazil
(1)
Nike China
(12)
Nike South Africa
(1)
North Macedonia
(1)
Norway
(1)
O'Neills
(1)
Oldham Athletic
(1)
Olympikus
(1)
Olympique Lyonnais
(1)
Page Viewer WebPart
(1)
Panama
(2)
Para
(1)
Paraguay
(2)
Penalty
(1)
Peru
(6)
Picture Manager
(1)
Poland
(2)
Ponte Preta
(1)
Portugal
(2)
Portuguesa RJ
(1)
problem
(2)
Puma
(46)
retro
(1)
review
(111)
Romai
(2)
Romania
(1)
RT Sports
(1)
Russia
(4)
Saeta
(1)
Sampaio Correa
(1)
Santarem
(1)
Santos
(2)
Sao Paulo FC
(1)
Sao Raimundo
(1)
scam
(2)
Score Draw
(1)
Search List with Count Displayed
(1)
Senegal
(3)
Serbia
(1)
Server Hardening
(1)
SESI Sao Paulo
(1)
Shandong Luneng
(1)
Shanghai Shenhua
(1)
Shanghai SIPG
(1)
SharePoint
(61)
SharePoint Connect to SQL
(2)
SharePoint Designer
(3)
Shenzhen FC
(1)
shirt
(232)
Sierra Leone
(1)
Singaporean Brand
(2)
Six5Six
(1)
Slovakia
(2)
Slovenia
(1)
Slow right click
(1)
Sondico
(1)
South Africa
(1)
Spain
(3)
SPS Services
(2)
Spurs
(1)
SQL Server 2008
(1)
SSP User Profile behaviour
(1)
Super Bolla
(2)
Sweden
(2)
Switzerland
(2)
Taubate Funvic
(1)
Team GB
(2)
techfit
(8)
Thai Brand
(3)
Thailand
(2)
Togo
(1)
Topper
(4)
track top
(13)
Travels
(1)
Trinidad and Tobago
(1)
Tunisia
(3)
Turkiye
(1)
tyro
(1)
UAE
(1)
UB
(3)
UB Electric
(3)
Ucan
(1)
UE Llagostera
(1)
Uganda
(1)
Uhlsport
(2)
Ukraine
(1)
Umbro
(18)
Umbro Brazil
(6)
Under Armour
(3)
Upload Center
(1)
Uruguay
(1)
Vasco Da Gama
(1)
Venezuela
(1)
Vietnam
(1)
Villa Nova
(1)
Villarreal
(1)
Vitoria
(1)
volleyball
(6)
Vozao
(1)
Wales
(1)
Warrix
(1)
water
(2)
WebClient
(4)
WebDav
(5)
West Ham
(2)
Where to get buy Iceland football shirt in Reykjavik
(1)
Win 8
(2)
Windows 10
(1)
Windows Scheduled Task
(1)
wish list
(1)
Workflow
(1)
World Cup 14
(9)
World Cup 18
(5)
Wuhan Zall
(1)
Xinjiang Tianshan Leopard
(1)
Xtep
(1)
Yanbian Funde
(1)
Yemen
(1)
Zambia
(1)
Zhejiang Greentown
(2)
Zimbabwe
(1)
Thursday, 14 May 2015
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment