LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to copy 2007 excel file formula results into a 2003 Excel file

Hi All,

This is the situation I am trying to solve.
I have an Excel 2007 file with loads of formulas, macros, conditional
formatting, etc... the client has got Office 2003 and therefore they
cannot view the file properly.

I saved them into 2003 compatible, and it does not work as it does not
traslate the formulas, but write #NAME? instead (not very helpful).

I worked around change the formulas into 2003 language but I can't as
they are already too long in 2007 so when I change them into 2003 I
need more code and it does not allow me.

I tried converters anddidn't work.

The funny thing of the situation is the client does not need to use
the file, but just read it, meaning, I just need a way to create a
copy of the same 2007 excel file with just the values, not the
calculations, macros, buttons, or formatting.

Any idea?

Thanks,
Nuria
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel File Protection 2003 vs. 2007 curious_rosebud Excel Discussion (Misc queries) 0 February 18th 09 10:15 PM
Opening Excel 2003 file in Excel 2007: Links do not work Roshan Q Excel Discussion (Misc queries) 5 January 10th 08 10:24 PM
2003 to 2007 Excel File Blom Excel Discussion (Misc queries) 5 March 30th 07 11:26 PM
Can't open Excel 2007 file with 2003 Colleen M Excel Discussion (Misc queries) 5 December 1st 06 03:01 AM
Excel 2003-how copy tab w/o file refs? Ian Elliott Excel Discussion (Misc queries) 2 August 25th 06 07:04 PM


All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"