trouble trading spreadsheets between 2010 and 2016 Excel

Duwamps · #1 02-15-2016, 04:52 PM

I created a spreadsheet with data and formulas in Excel 2010 and emailed it to a client who is using Excel 2016. She entered some data and returned the spreadsheet to me. All the original data and formulas have been replaced by links to the file as it existed in her Outlook cache, e.g.: 'C:\Users\Client\AppData\Local\Microsoft\Windows\T emporary Internet Files\Content.Outlook\OQF0O6JB\[2017 Moon&Ref Tables.xls]January'!M12

How do we stop this from happening and is it possible to rescue the spreadsheet as she saved it?

gebobs · #2 02-16-2016, 07:28 AM

Preventing, I have no idea. This has happened to me too. Annoying as all get out.

Rescuing, that's doable. All you need to do is do a find (the links) and replace (with "").

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with Microsoft Excel 2016	akkha	Excel	1	11-20-2015 09:37 PM
Excel problems since using Office 365 especially since 2016	USAOz	Excel	0	11-10-2015 09:06 PM
HELP - comparing spreadsheets in excel 2010	ali212006	Excel	1	04-03-2014 04:04 AM
Copy Column setting to other spreadsheets in an excel workbook	officeboy09	Excel	5	11-05-2013 01:49 AM
Odd Excel problem when 2010 spreadsheets	uchacker11	Excel	1	08-01-2011 04:24 AM