ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Data Disappears When Closed (https://www.excelbanter.com/excel-worksheet-functions/203851-data-disappears-when-closed.html)

Shawn

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

Sean Timmons

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


Spiky

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.


All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com