Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 271
Default Data Disappears When Closed

Hi,

I am working with an existing form in Excel. There are 4 tabs with
different forms in each tab. When I close the workbook, the data in two of
the 4 forms complete disappear. Is there something in Options or AutoFormat
that I should change?

This is Excel 2003 - Windows XP
--
Shawn
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,696
Default Data Disappears When Closed

That;s going to depend upon how the form is treating the data on the back
end. You'd have to look at the properties of the fields in the forms. If the
form isn't retaining some data, it may not have it tied to anything else...



"Shawn" wrote:

Hi,

I am working with an existing form in Excel. There are 4 tabs with
different forms in each tab. When I close the workbook, the data in two of
the 4 forms complete disappear. Is there something in Options or AutoFormat
that I should change?

This is Excel 2003 - Windows XP
--
Shawn

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default Data Disappears When Closed

What is the file extension? It should be ".xls" for a normal file. If
it is something else, that could be the problem.
Reply
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
data label disappears when I move it Tamara Charts and Charting in Excel 0 September 5th 08 12:14 AM
Data disappears!! Holey Excel Discussion (Misc queries) 5 February 27th 08 03:52 PM
F2 error: New data disappears when hit enter Will123 Excel Worksheet Functions 1 December 1st 06 03:19 PM
cell shows all the data, click out of it, end of data disappears LINDA Excel Discussion (Misc queries) 1 September 13th 06 04:28 PM
Data Validation list disappears [email protected] Excel Worksheet Functions 0 October 5th 05 04:14 PM


All times are GMT +1. The time now is 12:47 AM.

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

About Us

"It's about Microsoft Excel"