Thread
:
Formulas Changed when User Downloaded Spreadsheet
View Single Post
#
3
Posted to microsoft.public.excel.misc
galimi
external usenet poster
Posts: 210
Formulas Changed when User Downloaded Spreadsheet
Connie,
It may be the type of link in the formula changing. You may have a network
path that included in the formula that has changed to UNC style. Please post
the formula.
--
http://HelpExcel.com
516-984-0252
"Connie" wrote:
I have a situation which occurred when a user downloaded a spreadsheet
I created for him. I sent the spreadsheet zipped in a winzip file, and
the user unzipped the spreadsheet and copied it to their desktop. One
of the formulas on one of the sheets in the spreadsheet changed, and I
can't figure out how it changed. The cell was protected, so the user
couldn't possibly have changed it. I also sent the spreadsheet to
other users in the same office and they downloaded the file to their
desktops as well. The formula was correct for the other users. I'm
trying to avoid this situation in the future, and I'm wondering if
anyone else has had a similar thing happen. Everyone is on the correct
version of Excel (2003), macros were enabled, so I can't figure out how
the formulas changed. Any suggestions would be greatly appreciated!
Connie
Reply With Quote
galimi
View Public Profile
Find all posts by galimi