excel prob - cant save worksheet if someone has it open in a veiwe

S

Stephen

Client has a prob where they have some staff using 2003 excel viewer and if
they
have a workbook open in veiwer, then the accounts staff can't save their
changes in the same workbook in their Excel 2002 program without having to go
around to find and close the offending veiwer/s. Any way around this? is
this
a known MS prob? It seems that the veiwer tags it read only or something.
Have tried with making it a shered workbook but that doesn't seem to work
with the veiwers.
Thanks for any info
 
N

NickHK

I quick test with the Excel 2003 Viewer shows it able to open Shared
workbooks as Read-Only and whilst open in the Viewer, changes can be made
and saved in Excel.

Maybe something else is the cause.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel prob - cant save worksheet if someone has it open in a veiwe 1
excel prob - cant save worksheet if someone has it open in a veiwe 1
excel prob - cant save worksheet if someone has it open in a veiwe 8
On-Worksheet ActiveX Controls - is there a bug in the Excel engine?? 6
Conditional Formatting in Excel 2010 is being removed when I emailExcel Workbook 0
Problem in adding macro to ribbon through Add-in 7
Lose macros before saving 4
Corrupt files due to pivot remnants after saving via VBA 0

Top